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

Поиск
Список
Период
Сортировка
От Joe Van Dyk
Тема to_json(now()) result doesn't have 'T' separator
Дата
Msg-id CACfv+pLxT+YYJxFS2hwYrvu==FsGV4Ross7gj9bcgbEsyrfOjw@mail.gmail.com
обсуждение исходный текст
Ответы Re: to_json(now()) result doesn't have 'T' separator
Список 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 по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Seems like bug in 9.1.3, need to confirm.
Следующее
От: David Johnston
Дата:
Сообщение: Re: Seems like bug in 9.1.3, need to confirm.