Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
amontalbano
Contributor II
Contributor II

Table Transformation - Expression Builder - Local Time

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!

Labels (1)
1 Solution

Accepted Solutions
amontalbano
Contributor II
Contributor II
Author

Found the solution.  

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

 

View solution in original post

1 Reply
amontalbano
Contributor II
Contributor II
Author

Found the solution.  

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