From: filippo <filippo2991@virgilio.it>
To: pgsql-sql@postgresql.org
Subject: datestyle on windows environment: how to set?
Date: 31 May 2006 10:53:59 -0700
Message-ID: <1149098039.675748.226280@g10g2000cwb.googlegroups.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: filippo2991@virgilio.it
Subject: Re: datestyle on windows environment: how to set?
In-Reply-To: <1149098039.675748.226280@g10g2000cwb.googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox