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 6F2EF3ABBEE for ; Tue, 21 Dec 2004 06:18:42 +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 40103-06 for ; Tue, 21 Dec 2004 06:18:33 +0000 (GMT) Received: from a.relay.invitel.net (a.relay.invitel.net [62.77.203.3]) by svr1.postgresql.org (Postfix) with ESMTP id 07DA93ABB1B for ; Tue, 21 Dec 2004 06:18:27 +0000 (GMT) Received: from vadangyal.vnet.hu (mail.vnet.hu [213.163.59.4]) by a.relay.invitel.net (Invitel Core SMTP Transmitter) with ESMTP id 9AD7218CFC4 for ; Tue, 21 Dec 2004 07:18:21 +0100 (CET) Received: from [82.131.131.121] (82-131-131-121.vnet.hu [82.131.131.121]) by mail.vnet.hu (iPlanet Messaging Server 5.1 Patch 1 (built Jun 6 2002)) with ESMTPA id <0I920097E6ULQ8@mail.vnet.hu> for pgsql-sql@postgresql.org; Tue, 21 Dec 2004 07:18:21 +0100 (CET) Received: from 127.0.0.1 (AVG SMTP 7.0.296 [265.6.0]); Tue, 21 Dec 2004 07:18:28 +0100 Date: Tue, 21 Dec 2004 07:18:27 +0100 From: =?iso-8859-2?Q?Egy=FCd_Csaba_=28Freemail=29?= Subject: Re: Date datatype In-reply-to: <41C7631E.2010600@sa-sanmiguel.com> To: 'Pablo Digonzelli' , pgsql-sql@postgresql.org Message-id: <0I920097F6ULQ8@mail.vnet.hu> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Content-type: text/plain; charset=iso-8859-2 Content-transfer-encoding: 7BIT Thread-index: AcTnIXqYtZKWhqCSTRG950Y0/3L6TAAArhUg X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/142 X-Sequence-Number: 19762 Hi, I think the problem is the double quote you use. Try a single quote e.g.: update yourtable set birthdate='200-01-01' where ... This man must be a very old one... :) I tried it using timestamp not date, but I think it should work as well. bye, -- cs. -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Pablo Digonzelli Sent: Tuesday, December 21, 2004 12:41 AM To: pgsql-sql@postgresql.org Subject: [SQL] Date datatype 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. TIA Pablo ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 2004.12.17.