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
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!!! |