git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Use EncodeDateTime instead of to_char to render JSON timestamps.

author Andrew Dunstan <andrew@dunslane.net>

Tue, 3 Jun 2014 22:26:47 +0000 (18:26 -0400)

committer Andrew Dunstan <andrew@dunslane.net>

Tue, 3 Jun 2014 22:26:47 +0000 (18:26 -0400)

commit ab14a73a6ca5cc4750f0e00a48bdc25a2293034a

tree f2b0ad98b0346ed6824798052d752d9bd48e64ba tree

parent 0ad1a816320a2b539a51628e2a0b1e83ff096b1d commit | diff

Use EncodeDateTime instead of to_char to render JSON timestamps.

Per gripe from Peter Eisentraut and Tom Lane.

The output is slightly different, but still ISO 8601 compliant: to_char
doesn't output the minutes when time zone offset is an integer number of
hours, while EncodeDateTime outputs ":00".

The code is slightly adapted from code in xml.c

src/backend/utils/adt/json.c diff | blob | blame | history

src/test/regress/expected/json.out diff | blob | blame | history

src/test/regress/expected/json_1.out diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom