Re: Dates and daylight saving time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lockhart(at)fourpalms(dot)org
Cc: Fduch the Pravking <fduch(at)antar(dot)bryansk(dot)ru>, Tom Pfau <T(dot)Pfau(at)emCrit(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Dates and daylight saving time
Date: 2002-01-31 18:48:10
Message-ID: 4211.1012502890@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thomas Lockhart <lockhart(at)fourpalms(dot)org> writes:
> In the long run, we should probably implement some exact date/interval
> arithmetic instead of relying on timestamp types in the intermediate
> calculations.

AFAIK type "date" solves his problem just fine, and there's no need to
mess with timestamps and intervals at all. But in the long run it'd
be nice to handle this sort of situation more intuitively.

I have suggested more than once that type interval ought to have three
components not two: months, days, and seconds. Just as a month is not
a fixed number of days, a day is not a fixed number of seconds. Not
sure if we can get away with that when SQL92 believes otherwise, however.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Annie Bai 2002-01-31 19:11:06 Re: date format problem
Previous Message Thomas Lockhart 2002-01-31 18:06:34 Re: Dates and daylight saving time