X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1B5F9D1D1F2 for ; Tue, 9 Mar 2004 22:00:50 +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 73107-07 for ; Tue, 9 Mar 2004 18:00:49 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id E7C81D1D17E for ; Tue, 9 Mar 2004 18:00:45 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i29LxWAc000943; Tue, 9 Mar 2004 14:59:32 -0700 (MST) Date: Tue, 9 Mar 2004 14:59:16 -0700 (MST) From: "scott.marlowe" To: Dario Ottaviano Cc: Subject: Re: Problem with data format In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/160 X-Sequence-Number: 12729 What version of Postgresql are you running. Versions 7.2 and before would gladly swap around day / month when they needed to be to fit, and this caused me a few headaches where I had data feeds that were partially failing and couldn't figure out why. On Sat, 6 Mar 2004, Dario Ottaviano wrote: > That's ok, but how can i do that? > I tried something like "Set datestyle='European', but nothing changed! > > Please, can you help me! > Thank you, > Dario Ottaviano > > > "Tom Lane" ha scritto nel messaggio > news:14254.1078551909@sss.pgh.pa.us... > > "Dario Ottaviano" writes: > > > So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes > the > > > date 03/04/2004 (3 Apr 2004) into the table . > > > > You need to change the DateStyle setting to agree with your desired > > format. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >