Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] Postgresql datestyle From: Brinzoi Constantin Aurelian (aurel <email protected>)
Date: 01/09/01

Hi Nicholas !

Maybe you want to enter:

set datestyle to 'european';

It works ?

----- Original Message -----
From: "Sanders, Nicholas" <SandersN <email protected>>
To: "php-db <email protected> php. net (E-mail)" <php-db <email protected>>
Sent: Tuesday, January 09, 2001 7:27 PM
Subject: [PHP-DB] Postgresql datestyle

> Hi,
>
> Has anyone out there got any experience with datestyle in Postgresql
>
> I have an update like
>
> set datestyle to sql;
> set datestyle to european;
> update t_staff_dates set date_field = '1/2/2000' where id = 1;
>
> and when I do the following select
>
> set datestyle to sql;
> set datestyle to european;
> select * from t_staff_dates where id = 1;
>
> it returns 2/1/2000 (in the database it is '2000-01-02') so the select works
> but the update doesn't.
>
> Any ideas?
>
> Cheers
>
> Nick
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>