ISO 8601 DATE

FORMAT

TO_CHAR(TRUNC(date), 'YYYY-MM-DD') AS <column_name>

PARSE

TO_DATE(date, 'YYYY-MM-DD')  AS <column_name>

ISO 8601 TIMESTAMP UTC

FORMAT

TO_CHAR(timestamp, 'YYYY-MM-DD"T"HH24:MI:SS"Z"')  AS <column_name>

PARSE

TO_TIMESTAMP(?,'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"')  AS <column_name>