Обсуждение: Ignored PostgreSQL SET command

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?

2. Why is the command ignored?

=======================================================================
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/
  There is no wisdom, no insight, no plan that can succeed against
the LORD.   -- Proverbs 21:30
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010101
=======================================================================
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/

> 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.
                     - Thomas

"Patrick Dunford" wrote: >I have a line in a PHP script that looks like this: > >    $set=pg_exec($dbconn, "SET
DATESTYLETO 'European'"); //Set date format > >Since my ISP updated their server, this appears to be ignored as pgsql
>alwaysreturns dates in ISO format. > >1. What is the default format of dates returned that I can ALWAYS rely on? 
 
From release 7, the default format is ISO: yyyy-mm-dd
 >2. Why is the command ignored?

European has no meaning with the ISO datestyle.

To get normal European dates, do this SET command:
 SET DATESTYLE TO 'Postgres,European'

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Verily, verily, I say unto you, He that heareth my      word, and believeth
onhim that sent me, hath       everlasting life, and shall not come into       condemnation; but is passed from death
untolife."                      John 5:24