Hi all, it's possible to generate ISO8601 date string using function

to_iso8601

, but how to convert back the other way. The

to_tera_timestamp

does not accept the format.

select to_tera_timestamp('2025-02-03T09:15:33', 'yyyy-dd-mm"T"hh24:mi:ss');

Is there a different way?

Have you tried

str_to_date

select str_to_date('2025-02-03T09:15:33', '%Y-%m-%dT%H:%i:%s');

https://docs.starrocks.io/docs/sql-reference/sql-functions/date-time-functions/str_to_date/

Thanks, I haven't. I'm not quite sure how I've not seen it previously. I'm sure this will do the job for me