Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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')