Problem with intervals
От | Bob Smith |
---|---|
Тема | Problem with intervals |
Дата | |
Msg-id | AFC6FD04-2485-11D8-A180-0003933DD370@h-e.com обсуждение исходный текст |
Ответы |
Re: Problem with intervals
Re: Problem with intervals Re: Problem with intervals |
Список | pgsql-sql |
I'm getting an unexpected result using intervals in an expression: select ('2003-10-26 0:00:00'::timestamp + '1 day'::interval)::date; date ------------ 2003-10-26 (1 row) When I get rid of the date cast it becomes clear what is happening: select '2003-10-26 0:00:00'::timestamp + '1 day'::interval; ?column? ------------------------ 2003-10-26 23:00:00-08 (1 row) I assumed '1 day' would always increment the date by 1, but it appears that '1 day' just means '24 hours', and due to the daylight/standard time shift, October 26 was 25 hours long this year. Is this a Postgres bug, or is this correct SQL behavior? I'm running Postgres 7.2.2. Bob S.
В списке pgsql-sql по дате отправления: