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 322
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