how to get the data to datetime format

[WuCong]

I have one data, format is I want to get the date part and time part and to change to datetime format ?

I found 01JAN2022 is not a standard date format.

[rajeshkannanr · Accepted solution]

Hi Wu,

Greetings!

Thank you for reaching out to us. Here is the high-level overview of converting the column to DateTime format.

1. Split the column as Date and Time using the substring function.
2. Split the Date columns as Day, Month and Year.
3. Merge the columns Day, Month, and Year as separated by "-"
4. Finally, Merge Date and Time columns separated by space.

I have attached a screenshot of my transformer for your reference.

Regards,

Rajesh.

[WuCong]

thank you?Rajesh