I need to take the device time (which will always be local time to where the device is located). NOW() is taking time in UTC time zone. How to get the local time from the device?
Thanks, John. For those interested, FORMAT_DATETIME_LOCAL() return a text and therefore you can’t make operations with it. Use
DATETIME to convert back to date variable:
You can also use DATETIME() to format the result of a TIMESTAMP()