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 168143A2C5C for ; Tue, 21 Dec 2004 08:04:44 +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 71574-02 for ; Tue, 21 Dec 2004 08:04:32 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id EA8F63A2BD4 for ; Tue, 21 Dec 2004 08:04:31 +0000 (GMT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id iBL8c3T5020464; Tue, 21 Dec 2004 10:38:03 +0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id iBL8c3F0020460; Tue, 21 Dec 2004 10:38:03 +0200 Date: Tue, 21 Dec 2004 10:38:03 +0200 (EET) From: Achilleus Mantzios To: Pablo Digonzelli Cc: pgsql-sql@postgresql.org Subject: Re: Date datatype In-Reply-To: <41C7631E.2010600@sa-sanmiguel.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/143 X-Sequence-Number: 19763 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