Skip to main content

Hi Team,

we are just trying to convert the string timestamp format values to dateTime format in the expression transformation, when we tried to use  toDateTime(<column_name>,'YYYY-MM-DD HH🇲🇲ss','en') returning null- can someone help.

Is there any variable value am I missing, how to pass locale value in this expression, kind of stuck with this,

 

 

Hi @srini,

It looks like there's a minor issue with the format in your expression. Please try using the format below, and it should work as expected:

 

toDateTime(frm_where_clause,'yyyy-MM-dd HH:mm:ss')



I am seeing below result:
 

 

Reply


Community Terms of Use & ConditionsCookie settings