Skip to main content
Solved

Datetime conversion issues with locale and format

  • July 15, 2024
  • 2 replies
  • 92 views
S
Universe Traveller

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:mm:ss','en') returning null- can someone help.

Best answer by ivysakh

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:
 

 

Thanks again - Srini
A

2 replies

S
Universe Traveller
  • sriniUniverse Traveller
  • Author
  • Universe Traveller
  • July 15, 2024

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

 

 

Thanks again - Srini
A
ivysakh
Space Explorer
Forum|alt.badge.img+3
  • ivysakhSpace Explorer
  • Space Explorer
  • Answer
  • July 15, 2024

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:
 

 

Vysakh Indrasenan
A
A
Community Terms of Use & ConditionsCookie settingsAccessibility statement