Timstamp to Json conversion issue

Hi

 

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.

 

Seems json coversion is followed ISO8601 for the timestamp. This issue is resolved by sending “TIME” column as text instead of Timestamp without timezone.

 

But how do I fix this problem without converting to text.