Postgresql datestyle
| From: | Sanders, Nicholas | Date: | Tue, 09 Jan 2001 15:27:42 +0000 |
| Subject: | Postgresql datestyle | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5754@lists.php.net to get a copy of this message | ||
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