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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
talendstar
Creator
Creator

Date Time Formatting Issue

I am getting max value of a datetime field from Snowflake. When I print the value using tLog row I get a value like:

.-------------------.

|   tLogRow_1   |

|=-----------------=|

|UPDATEDATETIME   |

|=-----------------=|

|2021-07-24 03:18:16|

I also have a context variable defined with type of Date. When I print the value using tJavarow I get same date as printed using tlogrow however the format is entirely different:

Sat Jul 24 03:18:16 EDT 2021

I would like to get a value like the tlogrow in the context variable. Wondering how can fix this issue?

thanks

Labels (3)
1 Reply
gjeremy1617088143

Hi,

in the output schema date pattern of tlogrow:

 "yyyy-MM-dd HH:mm:ss"

Send me love and kudos