New Bug Encountered: UTCNOW() works wrong!

Nam_Toru
Participant I

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 311
9 REPLIES 9

Steve
Participant V

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.

Austin
Participant V

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

Austin
Participant V


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