Mixed data type to date and time


I’m unable to change a mixed data type to date and time.
On the “Clean Data” option, I’m able to change to text, integer and float only. Actually, I need to convert it to date and time to export as a csv.

How can I solve this issue?


this sounds that your data is not all timestamp format. please try:
select CAST (createdAt AS TIMESTAMP) AS createdAt from xxxx

replace xxxx with your dataset