Re: to_json(now()) result doesn't have 'T' separator

On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk <joe(at)tanga(dot)com> wrote:

> # select to_json(now());
> to_json
> ---------------------------------
> "2013-12-20 15:53:39.098204-08"
> (1 row)
>
> I'd like to see it output "2013-12-20T15:53:39.098204-08" so it's
> interchangeable with more systems.
>

Actually, "2013-12-20T15:53:39.44553-08:00" would be ideal.

>
>
> http://en.wikipedia.org/wiki/ISO_8601#Combined_date_and_time_representationssays 'T' can be omitted "by mutual agreement".
>
> I'm working with javascript/json systems that expect the 'T' to be there
> however, so there's no mutual agreement happening.
>
> Thoughts? I know I can hack around it by specifying my own date format,
> but I'd really like to be able to use row_to_json and other functions
> without specifying custom date formats everywhere.
>
> Joe
>