datestyle on windows environment: how to set?

From: "filippo" <filippo2991(at)virgilio(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: datestyle on windows environment: how to set?
Date: 2006-05-31 17:53:59
Message-ID: 1149098039.675748.226280@g10g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Miroslav Šulc 2006-05-31 21:34:43 DELETE ... USING ... - 8.0 and 8.1 compatibility problem
Previous Message Mario Splivalo 2006-05-30 15:09:54 Re: hi i need to encrypt one field in a table