> I have a line in a PHP script that looks like this:
> $set=pg_exec($dbconn, "SET DATESTYLE TO 'European'"); //Set date format
> Since my ISP updated their server, this appears to be ignored as pgsql
> always returns dates in ISO format.
> 1. What is the default format of dates returned that I can ALWAYS rely on?
ISO. Or you can start up the backend with a different default.
> 2. Why is the command ignored?
It is not (or, is probably not). The variant "European" affects month
and day ordering when specifying a date or when formatting a date with
the "Postgres" or "SQL" format.
You probably want
SET DATESTYLE TO 'SQL,European'
but ymmv. Check out the docs for more complete info, specifically the
chapter on data types.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2001-01-02 07:47:31|
|Subject: Re: [patch] src/include/storage/s_lock.h |
|Previous:||From: Bruce Momjian||Date: 2001-01-02 07:34:11|
|Subject: Re: [patch] src/include/storage/s_lock.h|