From: Tom Lane <tgl@sss.pgh.pa.us>
To: filippo <filippo2991@virgilio.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: datestyle on windows environment: how to set?
Date: Sat, 03 Jun 2006 22:10:11 -0400
Message-ID: <25935.1149387011@sss.pgh.pa.us> (raw)
In-Reply-To: <1149098039.675748.226280@g10g2000cwb.googlegroups.com>
References: <1149098039.675748.226280@g10g2000cwb.googlegroups.com>
"filippo" <filippo2991@virgilio.it> writes:
> I'd like to have
> DD-MM-YYYY for my timestamp field.
The closest display format to that is 'SQL, DMY':
regression=# set datestyle = 'sql, dmy';
SET
regression=# select current_date;
date
------------
03/06/2006
(1 row)
See the discussion of datestyle values in
http://www.postgresql.org/docs/8.1/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT
regards, tom lane
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: tgl@sss.pgh.pa.us, filippo2991@virgilio.it
Subject: Re: datestyle on windows environment: how to set?
In-Reply-To: <25935.1149387011@sss.pgh.pa.us>
* 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