Re: datestyle on windows environment: how to set? - Mailing list pgsql-sql

"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