Re: date problem and set style european

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)