date problem and set style european - Mailing list pgsql-general

From frank_lupo
Subject date problem and set style european
Date
Msg-id GYXK16$I6U5Bs6UBpsDIOy7P4RjYQbqFzZREKlDrg05RMT7gIN5Va@email.it
Whole thread Raw
Responses Re: date problem and set style european
List 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



pgsql-general by date:

Previous
From: Thirumoorthy Bhuvneswari
Date:
Subject: Query Speed!!!
Next
From: snpe
Date:
Subject: Compile from cvs