Table Transformation - Expression Builder - Local Time

amontalbano — Fri, 15 Oct 2021 14:34:17 GMT

I'm creating a new column to record the current date and time.

Using the strftime function, I have: strftime('%Y-%m-%d %H:%M:%f','now')

Is there an additional modifier to convert the time from UTC to my local time?

Thanks in advance!

Re: Table Transformation - Expression Builder - Local Time

amontalbano — Fri, 15 Oct 2021 17:15:51 GMT

Found the solution.

strftime('%Y-%m-%d %H:%M:%f','now','localtime')