Re: Timstamp to Json conversion issue

"Yelai, Ramkumar IN BLR STS" <ramkumar(dot)yelai(at)siemens(dot)com> writes:
> I have migrated my postgresql 9.2 schemas to Postgres 9.4 (only table scheme migrated not the data ). I have used the following sql to convert table output to json in 9.2.

> select array_to_json(array_agg(row_to_json(R.*)))::text from ( select " ID", " TIME" from "SN_TestTable" )R;

> IN 9.2, I used to get this result "[{"id":1,"time":"2015-01-13 12:09:45.348"}]"

> But same code in 9.4 produce this result "[{"id":1,"time":"2015-01-13T12:09:45.348"}]" . "T" separator is added between date and time.

This is an intentional change. As far as we know, any JSON processor that
reads timestamps should be happy with the "T", because that syntax is
required by the JSON RFC.

regards, tom lane