postgres iso date field code example
Example: get date ISO in psql
SELECT cast(to_char (now()::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') as varchar)
SELECT cast(to_char (now()::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') as varchar)