Tom Lane wrote:
>
> Cedar Cox <cedarc@visionforisrael.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