Thread

Re: [HACKERS] Last call?

Billy G. Allie <bill.allie@mug.org> — 1998-10-25T21:35:16Z

"Thomas A. Szybist" wrote:
> 
> I just gave today's (Oct 25) snapshot a try on Sparc Linux.  
> Looks good except datetime.   I'm getting failures due to this type 
> of thing:
> 
> regression=> SELECT ('today'::datetime );
> ?column?
> ----------------------------
> Sun Oct 25 00:00:00 1998 EDT
> (1 row)
> 
> regression=> SELECT  ('tomorrow'::datetime - '1 day'::timespan);
> ?column?
> ----------------------------
> Sun Oct 25 01:00:00 1998 EDT
> (1 row)                                                                        
> 
> 
> I *think* this may because we're not too far into EST yet.
> Sound good?
> 

This is not a failure.  The date 24 hours (1 day) before 'Mon Oct 26 00:00:00 1998 EST' is 'Sun Oct 25 01:00:00 1998 EDT'.  You would think it should be 'Sun Oct 25 00:00:00 1998 EST', but thanks to Daylight Savings Time that datetime does not exist :-)
-- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    |