date problem and set style european

From: "frank_lupo" <frank_lupo(at)email(dot)it>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: date problem and set style european
Date: 2002-07-08 12:29:30
Message-ID: GYXK16$I6U5Bs6UBpsDIOy7P4RjYQbqFzZREKlDrg05RMT7gIN5Va@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I instaled a postgresql 7.2 on win2000.
Problem:
1) when select a date the result is
gedis30=# SELECT CURRENT_TIMESTAMP AS today;
today
-------------------------------
2002-07-08 12:31:31.500692+00

2) I set a 'European' DATESTYLE but the result is
gedis30=# SET DATESTYLE to 'European';
SET VARIABLE
gedis30=# SELECT CURRENT_TIMESTAMP AS today;
today
-------------------------------
2002-07-08 12:37:09.150259+00
(1 row)

Help me for this problem

Bye !!
Frank Lupo (Wolf) !!

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Lettori Dvd, stereo hi - fi e lettori cd gratis solo su qx service.
Clicca e scoprirai che la tua estate in musica te la regaliamo noi.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=541&d=8-7

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felipe Nascimento 2002-07-08 13:01:00 Re: createuser --password
Previous Message Thirumoorthy Bhuvneswari 2002-07-08 12:24:28 Query Speed!!!