"Yelai, Ramkumar IN BLR STS" <ramkumar.yelai@siemens.com> writes:
> I have migrated my postgresql 9.2 schemas to Postgres 9.4 (only table scheme migrated not the data ). I have used
thefollowing 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
betweendate 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