Re: non-us datestyle

Tom Lane wrote:
>
> Cedar Cox <cedarc(at)visionforisrael(dot)com> writes:
> > Is there a way to set the default date style to non-US (European)?
>
> You can set PGDATESTYLE in the postmaster's environment, I think.
>
> This should be a GUC variable (hence settable in postgresql.conf)
> but isn't yet.
>

psqlodbc driver seems to set the DateStyle for itself in
interfaces/odbc/connection.c.

/* Set the Datestyle to the format the driver expects it to be in */
result = SQLExecDirect(hstmt, "set DateStyle to 'ISO'", SQL_NTS);

regards,
Hiroshi Inoue