New Bug Encountered: UTCNOW() works wrong!

I used UTCNOW() for my app to get UTC time (not local time), and it worked in the past.
But now, today (Oct 13 2020), it doesn’t work. When I change time on my laptop then that time (UTCNOW) change also to my device time.
Plz check it. Thanks!

0 9 317
9 REPLIES 9

Steve
Platinum 4
Platinum 4

This is not a bug. UTCNOW() simply returns the time of your device with no timezone adjustment.

but docs is saying it returns UTC?

UTC is–by definition–the current time with no timezone adjustment.

and wouldn’t UTCNOW mean that its the time in UTC and NOW mean current device time?


UTC by definition is time at 0 longitude?

As I understand it.

The UTCNOW() value is calculated like your device’s TIMENOW() - 3 hours (Your location in your mobilde device).

hmmmm

I m bit puzzled now…

I just simply put now() and utcnow() to virtual column, which returns

3X_4_4_4429fa0be2c9175ac7ffde2b023d128585802e74.png

Working fine (par on my understanding)…

Oh it is late now, i go to bed now.

So. You are living in GMT+9

Top Labels in this Space