UTC Time Issue?

Hi,

Is anyone facing issue while storing current time in UTC?
I have this expression UTCNOW() in few of my timestamp columns but it seems to be updating in other timezones?

Is this a bug?

@devingu 

1 3 233
3 REPLIES 3


@YogeshLaddha wrote:

it seems to be updating in other timezones?


If you have concerns about the reliability of any kind of datetime I suggest you to have server-side ways to save it. This means a bot saving the server's timestamp instead of the user's one.

Afaik, UTCNOW() just considers the time offset of the current user compared to UTC based on the timezone the user is, but doesn't mean that if the user is using a wrong timezone, for example, the system would return the right UTC.

Edit: Confirmed by the documentation where this behaviour is clearly explained:
UTCNOW() - AppSheet Help


@SkrOYC wrote:

Confirmed by the documentation where this behaviour is clearly explained


Thanks again, @lizlynch! I know you often hear about inadequate documentation. Don't miss this case of helpful documentation--your efforts pay off!

Thanks, @dbaum ! It's a team effort. Thank you for always bringing the doc improvements to our attention!

Top Labels in this Space