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/


Tue, 2 Jan 2001 17:14:02 +1300
"Patrick Dunford" <pdunford.webs@clear.net.nz>
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?

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

Tue, 02 Jan 2001 07:47:06 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: Ignored PostgreSQL SET command
"Patrick Dunford" wrote:
  >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?
  
>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 on him that sent me, hath  
      everlasting life, and shall not come into  
      condemnation; but is passed from death unto life."    
                   John 5:24 



Tue, 02 Jan 2001 07:59:26 +0000
"Oliver Elphick" <olly@lfix.co.uk>
Re: Ignored PostgreSQL SET command 