Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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