SET TIMEZONE doesn't affect to SELECT statement

Поиск
Список
Период
Сортировка
Искать

SET TIMEZONE doesn't affect to SELECT statement

От:
POST <post@centrum.sk>
Дата:

Re: SET TIMEZONE doesn't affect to SELECT statement

От:
Mike Christensen <mike@kitchenpc.com>
Дата:
Strange, maybe there's some server setting because I get different results on mine..

set timezone to 'Europe/London';
select '2008-01-01 12:00:00 GMT+2'::timestamptz;
Result: '2008-01-01 14:00:00+00'


set timezone to 'Europe/Moscow';
select '2008-01-01 12:00:00 GMT+2'::timestamptz;
Result: '2008-01-01 17:00:00+03'

2009/6/18 POST <post@centrum.sk>

Hello; by tutorial I have tried the example:


set timezone to 'Europe/London';

select '2008-01-01 12:00:00 GMT+2'::timestamptz;


Result: 2008-01-01 15:00:00



set timezone to 'Europe/Moscow';

select '2008-01-01 12:00:00 GMT+2'::timestamptz;


Result: 2008-01-01 15:00:00



Why is the result identical ? Is something wrong ?


Thanks for suggestion.


FAQ