On Mon, Dec 2, 2013 at 10:22:47PM +0900, MauMau wrote: > I'm sorry I didn't respond for a long time. I've come up with a suggestion. > > The original reporter of this problem expected the output of the > date type in 'Postgres,DMY' style to be "17 Dec 1997", when the > output of the timestamp if "Wed 17 Dec 07:37:16 1997 PST". He > thought so by reading the following sentence: > > http://www.postgresql.org/docs/current/static/datatype-datetime.html > The output of the date and time types is of course only the date or > time part in accordance with the given examples. > > However, the actual output of the date type in Postgres style is: > > * 12-17-1997 if datestyle is 'Postgres,YMD' or 'Postgres,MDY' > * 17-12-1997 if datestyle is 'Postgres,DMY' > > So, my suggestion is to just add the following sentence right after > the above one. > > The Postgres style is an exception: the output of the date type is > either MM-DD-YYYY (e.g. 12-17-1997) or DD-MM-YYYY (e.g. 17-12-1997), > which is different from the date part of the output of the timestamp > type. > > Could you consider and add this to the manual?
Yes, I will make the change unless someone objects. -- Bruce Momjian <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
