Re: DATE type output does not follow datestyle parameter - Mailing list pgsql-general

From: "Adrian Klaver" <adrian.klaver@gmail.com>
> Actually the relevant code seems to be here:
>
> /src/ backend/parser/gram.y
>
>
> CURRENT_DATE
>                                {
>                                        /*
>                                         * Translate as
> "'now'::text::date".
>                                         *
> ....
>
> CURRENT_TIMESTAMP
>                                {
>                                        /*
>                                         * Translate as "now()", since
> we have a function that
>                                         * does exactly what is needed.
> ...
>
>
> Also from :
>
> 8.5.1.4. Special Values
>
> The following SQL-compatible functions can also be used to obtain the
> current time value for the corresponding data type: CURRENT_DATE,
> CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP. The latter
> four accept an optional subsecond precision specification. (See Section
> 9.9.4.) Note that these are SQL functions and are not recognized in data
> input strings.
>
>
>
> It would seem the functions are special cased.


As below, normal DATE constants also does not follow the setting of
datestyle.  Is this a bug?

SET datestyle = 'Postgres, MDY';
SELECT DATE 'Jan 2 2013';
    date
------------
 01-02-2013
(1 row)

Regards
MauMau