In date getting Unparsable error

sgnarkhede2016

Hello,
I have one column that contain date in "19-JAN-21 11.53.15.409000000 AM" this fromat with nominal datatype when I trying to convert nominal to date with mm/dd/yyyy format getting unparsable format

jacobcybulski

Hi @sgnarkhede2016, @BalazsBarany is correct you need to specify the correct format for the conversion of a nominal to date format. You have used "mm/dd/yyyy" however the date-time format for your field is more complex, i.e. "dd-MM-yy hh.mm.ss.S a". Once you parse the date-time string, you will have a proper internal representation useful for any date-time related manipulation; and if you want to split it into components or convert it to a string of another format you can using other operators.

BalazsBaranyRM

Hi @sgnarkhede2016,

you need to specify the correct format for the conversion. The operator help contains all the necessary characters for specifying the custom format.

Converting with the wrong format (the one you selected) leads to the conversion error.

Regards,
Balázs

jacobcybulski

Hi @sgnarkhede2016, @BalazsBarany is correct you need to specify the correct format for the conversion of a nominal to date format. You have used "mm/dd/yyyy" however the date-time format for your field is more complex, i.e. "dd-MM-yy hh.mm.ss.S a". Once you parse the date-time string, you will have a proper internal representation useful for any date-time related manipulation; and if you want to split it into components or convert it to a string of another format you can using other operators.