Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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')