Re: possible time change issue - known problem?
От | Dan Langille |
---|---|
Тема | Re: possible time change issue - known problem? |
Дата | |
Msg-id | 3E915FCD.5142.A974A3C@localhost обсуждение исходный текст |
Ответ на | Re: possible time change issue - known problem? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
On 7 Apr 2003 at 10:50, Tom Lane wrote: > "Dan Langille" <dan@langille.org> writes: > > On 7 Apr 2003 at 10:32, Tom Lane wrote: > >> Type INTERVAL knows about months and seconds, nothing else. > > > Hmmm, months and seconds only. Then is the documentation wrong? > > No, the docs are right, but the physical storage is months and seconds. > For instance, '1 year' becomes '12 months' (okay) and '1 week' becomes > '604800 seconds' (not so okay). Adding 'day' as a basic element would > allow correct handling of cross-DST-boundary cases. Ahhhh, OK, I understand. > >> I've opined in the past that it should be months, days, and seconds, > >> but no one seems excited enough about the issue to do the nontrivial > >> work involved ... > > > If it truly is that trivial, please point me at the file I need to > > hack. > > Didn't I just say that I think it's *not* trivial? But anyway, the > interval-related functions are in some subset of *cough* yes, sorry, I misunderstood. So much for my spending the rest of today fixing it... -- Dan Langille : http://www.langille.org/
В списке pgsql-general по дате отправления: