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" <[EMAIL PROTECTED]>
To: "Pablo Digonzelli" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED]
-- -Achilleus
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
