Re: Date datatype

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(at)matrix(dot)gatewaynet(dot)com>
To: "Pablo Digonzelli" <pdigonze(at)sa-sanmiguel(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org
>>
>
> --
> -Achilleus
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org