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
Post a Comment