or,
# update table set birthdate = to_date('2000-01-01','YYYY-MM-DD');
I'm not sure which is better though I tend to do it this way.
regards
Iain
----- Original Message -----
From: "Achilleus Mantzios" <achill@matrix.gatewaynet.com>
To: "Pablo Digonzelli" <pdigonze@sa-sanmiguel.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, December 21, 2004 5:38 PM
Subject: Re: [SQL] Date datatype
>O Pablo Digonzelli έγραψε στις Dec 20, 2004 :
>
>> hi all,
>> Ca anyone send me an example how to update a date datatype?
>> for example
>> update table set birthdate = "200-01-01" doesnt work.
>
> # update table set birthdate = '2000-01-01';
>
>>
>> TIA
>> Pablo
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>
> --
> -Achilleus
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org