| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | frank_lupo <frank_lupo(at)email(dot)it> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: date problem and set style european |
| Date: | 2002-07-08 14:54:47 |
| Message-ID: | 1026140087.26310.4.camel@linda |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2002-07-08 at 13:29, frank_lupo wrote:
> 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
bray=# set datestyle to 'SQL,European';
SET VARIABLE
bray=# SELECT CURRENT_TIMESTAMP AS today;
today
--------------------------------
08/07/2002 15:52:06.774377 BST
(1 row)
bray=# set datestyle to 'Postgres,European';
SET VARIABLE
bray=# SELECT CURRENT_TIMESTAMP AS today;
today
-------------------------------------
Mon 08 Jul 15:52:31.031277 2002 BST
(1 row)
bray=# set datestyle to 'iso';
SET VARIABLE
bray=# SELECT CURRENT_TIMESTAMP AS today;
today
-------------------------------
2002-07-08 15:54:06.472742+01
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-08 15:21:51 | Re: 7.2.1 optimises very badly against 7.2 |
| Previous Message | Nigel J. Andrews | 2002-07-08 14:53:52 | Re: pgaccess problems |