set datestyle to European PROBLEM

From: Alessandro Rossi <alex(at)sunrise(dot)radiostudiodelta(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: set datestyle to European PROBLEM
Date: 2001-06-15 07:59:46
Message-ID: Pine.LNX.4.05.10106150951100.6628-100000@sunrise.radiostudiodelta.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I have the defaul installation of postgres 7.0.3 and on another machine
7.1.2 on redhat 7.1

I cannont get the date in correct form:

dbme=# select data_ar from equipment limit 5;
data_ar
------------
2001-11-05
2001-05-17
2001-05-28
2001-05-28
2001-05-22
(5 rows)

then:

dbme=# set datestyle to European;
SET VARIABLE

dbme=# select data_ar from equipment limit 5;
data_ar
------------
2001-11-05
2001-05-17
2001-05-28
2001-05-28
2001-05-22
(5 rows)

Is this a bug ?

I think i should get dd-mm-yyy date format and not yyyy-mm-dd

Is postgres using ISO date format as default ?

Thanks

Alex

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2001-06-15 11:30:39 Re: search/replace in update
Previous Message Postgresql 2001-06-15 07:41:42 calling user defined functions with parameters.. ?