From: Iain <iain@mst.co.jp>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Pablo Digonzelli <pdigonze@sa-sanmiguel.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Date datatype
Date: Tue, 21 Dec 2004 19:07:44 +0900
Message-ID: <000601c4e744$ed43c350$7201a8c0@mst1x5r347kymb> (raw)
References: <Pine.LNX.4.44.0412211037330.20459-100000@matrix.gatewaynet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: iain@mst.co.jp, achill@matrix.gatewaynet.com, pdigonze@sa-sanmiguel.com
Subject: Re: Date datatype
In-Reply-To: <000601c4e744$ed43c350$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox