to_json(now()) result doesn't have 'T' separator - Mailing list pgsql-general

From Joe Van Dyk
Subject to_json(now()) result doesn't have 'T' separator
Date
Msg-id CACfv+pLxT+YYJxFS2hwYrvu==FsGV4Ross7gj9bcgbEsyrfOjw@mail.gmail.com
Whole thread Raw
Responses Re: to_json(now()) result doesn't have 'T' separator
List pgsql-general
# 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. 


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

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Seems like bug in 9.1.3, need to confirm.
Next
From: David Johnston
Date:
Subject: Re: Seems like bug in 9.1.3, need to confirm.