Hello,
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