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 12F2BD1D300 for ; Sat, 6 Mar 2004 20:51:36 +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 21980-02 for ; Sat, 6 Mar 2004 16:51:30 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 600AED1D2AC for ; Sat, 6 Mar 2004 16:51:28 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i26KpH1Y040041 for ; Sat, 6 Mar 2004 20:51:17 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i26Kd2Kq038565 for pgsql-admin@postgresql.org; Sat, 6 Mar 2004 20:39:02 GMT From: "Dario Ottaviano" X-Newsgroups: comp.databases.postgresql.admin References: <1L82c.51237$Kc3.1570257@twister2.libero.it> <14254.1078551909@sss.pgh.pa.us> Subject: Re: Problem with data format Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Sat, 06 Mar 2004 20:39:12 GMT X-Complaints-To: abuse@libero.it Organization: [Infostrada] To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/152 X-Sequence-Number: 12721 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 >