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)