RE: [PHP-DB] Postgresql datestyle

It doesn't seem to make any difference. It recognises the 'set datestyle' in the select statement but doesn't work for the update one? -----Original Message----- From: Brinzoi Constantin Aurelian [mailto:aurel@irecson.ro] Sent: 09 January 2001 15:43 To: Sanders, Nicholas; php-db@lists. php. net (E-mail) Subject: Re: [PHP-DB] Postgresql datestyle Hi Nicholas ! Maybe you want to enter: set datestyle to 'european'; It works ? ----- Original Message ----- From: "Sanders, Nicholas" <SandersN@logica.com> To: "php-db@lists. php. net (E-mail)" <php-db@lists.php.net> 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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net