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

Announcements
Join us in Bucharest on Sept 18th 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