Skip to main content
Solved

Datetime conversion issues with locale and format

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:
 

 

View original
Thanks again - Srini

S
Universe Traveller
  • sriniUniverse Traveller
  • 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
Cansu
1 person likes this
  • Cansu
    Cansu
ivysakh
Space Explorer
Forum|alt.badge.img+3
  • ivysakhSpace Explorer
  • Space Explorer
  • 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

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings