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.
Solved
Datetime conversion issues with locale and format
- Data Pioneer
Best answer by ivysakh
Hi
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:
- Data Pioneer
Is there any variable value am I missing, how to pass locale value in this expression, kind of stuck with this,
+3- Space Explorer
- Answer
Hi
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:
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.