postgresql - Turn postgres date representation into ISO 8601 string -


i'm trying format postgres date representation iso 8601 string. i'm assuming there postgres function can it, found documentation short on examples.

my query

select   now()::timestamp 

which returns

[{{2016, 8, 9}, {3, 56, 55, 754181}}] 

i'm trying date format looks more 2016-8-9t03:56:55+00:00.

what changes need make query make happen? help.

i think found way formatting, it's not ideal because i'm writing formatting myself.

here potential solution:

select to_char (now()::timestamp @ time zone 'utc', 'yyyy-mm-dd"t"hh24:mi:ss"z"') 

Comments