Skip site navigation (1) Skip section navigation (2)

Ignored PostgreSQL SET command

From: "Patrick Dunford" <pdunford(dot)webs(at)clear(dot)net(dot)nz>
To: "PostgreSQL List" <pgsql-hackers(at)postgresql(dot)org>, <php-general(at)lists(dot)php(dot)net>
Subject: Ignored PostgreSQL SET command
Date: 2001-01-02 04:14:02
Message-ID: 000701c07472$7045f2e0$3acda7cb@patrickspc (view raw or flat)
Thread:
Lists: pgsql-hackers
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/


Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-01-02 04:59:56
Subject: Re: PHP and PostgreSQL
Previous:From: Rod TaylorDate: 2001-01-02 04:08:16
Subject: Re: PHP and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group