Date Time Formatting Issue

talendstar — Sat, 24 Jul 2021 22:46:59 GMT

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

Re: Date Time Formatting Issue

gjeremy1617088143 — Sun, 25 Jul 2021 05:57:35 GMT

Hi,

in the output schema date pattern of tlogrow:

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

Send me love and kudos

topic Re: Date Time Formatting Issue in Talend Studio

Date Time Formatting Issue

Re: Date Time Formatting Issue