Re: BUG #12578: row_to_json() and to_json() add 'T' in timestamp field.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: yoonghm(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12578: row_to_json() and to_json() add 'T' in timestamp field.
Date: 2015-01-17 15:59:17
Message-ID: 21765.1421510357@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

yoonghm(at)gmail(dot)com writes:
> row_to_json and to_json replace the space between date and time.

This is not a bug; it's an intentional behavioral change. Per the
third bullet point in the 9.4 release notes:

* When converting values of type date, timestamp or timestamptz to JSON,
render the values in a format compliant with ISO 8601 (Andrew Dunstan)

Previously such values were rendered according to the current DateStyle
setting; but many JSON processors require timestamps to be in ISO 8601
format. If necessary, the previous behavior can be obtained by
explicitly casting the datetime value to text before passing it to the
JSON conversion function.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hor Meng Yoong 2015-01-17 17:27:41 Re: BUG #12578: row_to_json() and to_json() add 'T' in timestamp field.
Previous Message yoonghm 2015-01-17 09:55:00 BUG #12578: row_to_json() and to_json() add 'T' in timestamp field.