X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A8258D1E14E for ; Fri, 20 Feb 2004 15:32:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12811-05 for ; Fri, 20 Feb 2004 11:32:32 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 58C19D1D25D for ; Fri, 20 Feb 2004 11:32:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1KFWQbB028037; Fri, 20 Feb 2004 10:32:27 -0500 (EST) To: Silke Trissl Cc: pgsql-sql@postgresql.org Subject: Re: date format in 7.4 In-reply-to: <40362082.7070900@informatik.hu-berlin.de> References: <40362082.7070900@informatik.hu-berlin.de> Comments: In-reply-to Silke Trissl message dated "Fri, 20 Feb 2004 15:58:10 +0100" Date: Fri, 20 Feb 2004 10:32:26 -0500 Message-ID: <28036.1077291146@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/307 X-Sequence-Number: 16997 Silke Trissl writes: > On 7.3 I run several tests about the format of the date and found, > that Postgres accepts almost everything. Today I found out, that 7.4.1 > only accepts dates in the format mm-dd-yy, It now requires the field order to be what DateStyle says it is. See the very voluminous flamewar about ambiguous date input handling in the pgsql-hackers archives from last summer. > although the documentation still states the following AFAICS the documentation says so too... regards, tom lane