Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 44CB82E34E1 for ; Thu, 24 Jan 2008 18:21:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 86135-01-2 for ; Thu, 24 Jan 2008 18:20:46 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id CF2292E4143 for ; Thu, 24 Jan 2008 16:59:53 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so654718waf.5 for ; Thu, 24 Jan 2008 12:59:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=TgCWU7gvqSbwtzI+n7mmeRh1gvQ30MJ+Lzraen3L2C0=; b=VSoko4Lle0mQGaIv5ao4xkzwXw6MVO1uMBpgL5tfp6F1pE1t6QS0HFBSPqAnnH80Fv6oTpcOMns1mh72ZaZZ/mSFSKOG2zQxW4kZgEa6gHsHsvu5qp+EnOZnq1muelN1XE3lZJOGdrva+zVqv0L01c+OYUavjsDwctR3Gl27uys= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WSh7jnN9TNKTZewGGVlqxDlCSWfES36tC0tLPj0OG5r343Uz8BNf/LLEJX0wJ47qcsIHW+XMKEvtbJrK7tZhJPCgRrZ9ZVvkEngvFkjQQkJ6e11Z+ZKuW68InD4xTTVTTNt05Z/0VNwIucfKvetkifVmchDJulibdiDy2isJAnk= Received: by 10.114.169.2 with SMTP id r2mr1316166wae.76.1201208392792; Thu, 24 Jan 2008 12:59:52 -0800 (PST) Received: by 10.114.133.5 with HTTP; Thu, 24 Jan 2008 12:59:52 -0800 (PST) Message-ID: Date: Thu, 24 Jan 2008 14:59:52 -0600 From: "Scott Marlowe" To: iuri.sampaio@computer.org Subject: Re: date format Cc: "SQL Postgresql List" In-Reply-To: <1201195442.5996.4.camel@COMPAQ> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1201162018.7883.12.camel@COMPAQ> <1201195442.5996.4.camel@COMPAQ> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/185 X-Sequence-Number: 30038 Please keep replies on list. Others might have input that will help. On Jan 24, 2008 11:24 AM, iuri de araujo sampaio w= rote: > Yes, I am trying to insert the string =B42008 7 22=B4 as a date. > and i can=B4t change the input format. Is that a edit the default format > type date, in order to postgresql accept thi > s input? Are you trying to insert '2008 7 22' or '2008 7 22 {} {} {} {DD MONTH YYYY}' as a date? If I try this: create table test (dt date); insert into test values ('2008 7 22'); INSERT 0 1 select * from test; dt ------------ 2008-07-22 (1 row) It works. However, that other string is most certainly NOT a date. Note I'm running pgsql 8.2.6 on ubuntu, just fyi.