presto_iso8601_basic_format.sql

WITH CTE AS (
    SELECT
      concat(
        substr('20220416T070044.243Z', 1, 4), '-',
        substr('20220416T070044.243Z', 5, 2), '-',
        substr('20220416T070044.243Z', 7, 2), 'T',
        substr('20220416T070044.243Z', 10, 2), ':',
        substr('20220416T070044.243Z', 12, 2), ':',
        substr('20220416T070044.243Z', 14)
      ) as ts
)
select from_iso8601_timestamp(ts) from CTE