Re: date problem and set style european
От | Oliver Elphick |
---|---|
Тема | Re: date problem and set style european |
Дата | |
Msg-id | 1026140087.26310.4.camel@linda обсуждение исходный текст |
Ответ на | date problem and set style european ("frank_lupo" <frank_lupo@email.it>) |
Список | 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)
В списке pgsql-general по дате отправления: