X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 7CFF53AAC85
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 21 Dec 2004 10:06:21 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 15000-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 21 Dec 2004 10:06:14 +0000 (GMT)
Received: from millenium.mst.co.jp (unknown [210.230.185.241])
	by svr1.postgresql.org (Postfix) with ESMTP id 31B813A6E99
	for <pgsql-sql@postgresql.org>; Tue, 21 Dec 2004 10:06:15 +0000 (GMT)
Received: from mst1x5r347kymb (lc12114 [192.168.1.114])
	by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id iBLA5nZ29844;
	Tue, 21 Dec 2004 19:05:49 +0900
Message-ID: <000601c4e744$ed43c350$7201a8c0@mst1x5r347kymb>
From: "Iain" <iain@mst.co.jp>
To: "Achilleus Mantzios" <achill@matrix.gatewaynet.com>,
	"Pablo Digonzelli" <pdigonze@sa-sanmiguel.com>
Cc: <pgsql-sql@postgresql.org>
References: <Pine.LNX.4.44.0412211037330.20459-100000@matrix.gatewaynet.com>
Subject: Re: Date datatype
Date: Tue, 21 Dec 2004 19:07:44 +0900
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="ISO-8859-7";
	reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200412/145
X-Sequence-Number: 19765

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