X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 862C69FA5E9 for ; Wed, 31 May 2006 14:54:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96330-04 for ; Wed, 31 May 2006 14:54:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id C69FF9FA5E1 for ; Wed, 31 May 2006 14:54:08 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 305FD31D9B; Wed, 31 May 2006 19:54:07 +0200 (MET DST) From: "filippo" X-Newsgroups: pgsql.sql Subject: datestyle on windows environment: how to set? Date: 31 May 2006 10:53:59 -0700 Organization: http://groups.google.com Lines: 36 Message-ID: <1149098039.675748.226280@g10g2000cwb.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Media Center PC 3.0; .NET CLR 1.0.3705; InfoPath.1),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: g10g2000cwb.googlegroups.com; posting-host=151.37.79.115; posting-account=MMcEjg0AAAA--8UL7aBU2jn4y8fFaVqr To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/49 X-Sequence-Number: 25285 Hello, I want to set the datestyle = 'ISO, European' for all my databases. I put that configuration into postgresql.conf file, but I didn't succeed. After rebooting all dates are like that: YYYY-MM-DD I'd like to have DD-MM-YYYY for my timestamp field. I have the latest version of pgsql and perl. Hereafter is an extract of my postgresql.conf file. Thanks and best regards, Filippo # - Locale and Formatting - datestyle = 'ISO, European' #timezone = unknown # actually, defaults to TZ # environment setting #australian_timezones = off #extra_float_digits = 0 # min -15, max 2 #client_encoding = sql_ascii # actually, defaults to database # encoding # These settings are initialized by initdb -- they might be changed lc_messages = 'C' # locale for system error message # strings lc_monetary = 'C' # locale for monetary formatting lc_numeric = 'C' # locale for number formatting lc_time = 'C' # locale for time formatting