Skip to main content
Solved

Datetime conversion issues with locale and format

  • 15 July 2024
  • 2 replies
  • 25 views

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.

2 replies

S
Rank

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

 

 

Thanks again - Srini
ivysakh
Rank
Badge +3

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