Re: pgsql: Add 'day' field to INTERVAL so 1 day interval

Bruce Momjian wrote:
> Log Message:
> -----------
> Add 'day' field to INTERVAL so 1 day interval can be distinguished from
> 24 hours. This is very helpful for daylight savings time:
>
> select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours';
> ?column?
> ----------------------
> 2005-05-04 01:00:00-04
>
> select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day';
> ?column?
> ----------------------
> 2005-05-04 01:00:00-04

Oops, meant:

SELECT '2005-04-03 00:00:00'::timestamp WITH TIME ZONE + '1 day';
?column?
------------------------
2005-04-04 00:00:00-04

SELECT '2005-04-03 00:00:00'::timestamp WITH TIME ZONE + '24 hours';
?column?
------------------------
2005-04-04 01:00:00-04

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073