Re: 8.3: timestamp subtraction
От | Daniel Verite |
---|---|
Тема | Re: 8.3: timestamp subtraction |
Дата | |
Msg-id | 6d716826-b95c-4241-a1f6-1aa3b5741f7d@mm обсуждение исходный текст |
Ответ на | 8.3: timestamp subtraction (Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>) |
Ответы |
Re: 8.3: timestamp subtraction
|
Список | pgsql-general |
Havasvölgyi Ottó wrote: > I don't know why this query returns false: > > SELECT '20040506 070809.010000'::timestamp(6) - '20010203 > 040506.007000'::timestamp(6) = '1188 day 3 hour 3 minute 3 second 3 > millisecond'::interval; > If I just subtract the two timestamps, its result is the interval I > specified. > > What may cause this? It works for me: test=> SELECT '20040506 070809.010000'::timestamp(6) - '20010203 040506.007000'::timestamp(6)= '1188 day 3 hour 3 minute 3 second 3 millisecond'::interval; ?column? ---------- t (1 row) test=> select version(); version ----------------------------------------------------------------------- ----------------------------- PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.2-1ubuntu11) 4.3.2 (1 row) Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
В списке pgsql-general по дате отправления: