• Marc G. Fournier's avatar
    From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> · 28454c21
    Marc G. Fournier authored
    Subject: Re: [HACKERS] abstime "now" broken
    
    Yes, I broke 'now' :( with an attempt at a bug fix involving
    servers running in the UTC/GMT timezone. These patches fix
    the problem, and have been tested in GMT (+00 hours),
    PST (-08), and NZT (+12) timezones which exercized the code for
    various cases including across day boundaries.  btw, this code
    fixes the same type of problem for 'today', 'yesterday', 'tomorrow',
    for DATETIME, ABSTIME, DATE and TIME types.
    
    The bugfix itself is quite small, but I have accumulated other
    changes in the datetime data type and include them here also.
    One set of changes involves printing ISO-formatted dates and
    is in response to the helpful information from Kurt Lidl regarding
    ANSI SQL dates. I'll send another e-mail sometime soon discussing
    more issues he has raised...
    28454c21
dt.h 8.94 KB