Hello, I have a excel database where there is a date column. I try to change the format of this column using this function :
CAST( column_name AS timestamp)
But it shows me a lot of empty value and its not supposed to...
For some raws its working but not all of them
Do you have an idea ?
+14Hi, you can double check the field if the format is consistent,
you can also use TO_TIMESTAMP(column_name ,'YYYY-MM-DD HH:MM:SS') to explicitly define the format of the column_date
BR,
Rio
Another option would be to test the difference with the CAST(column_name AS DATETIME) option. This works for me at least in data transformations.
Another option would be to transform it within the knowledge model using the TO_DATE functionality.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
