Re: [HACKERS] Last call?
Billy G. Allie <bill.allie@mug.org>
From: "Billy G. Allie" <Bill.Allie@mug.org>
To: "Thomas A. Szybist" <szybist@boxhill.com>
Cc: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>, Postgres Hackers List <hackers@postgreSQL.org>, Postgres Documentation List <docs@postgreSQL.org>, geek+@cmu.edu, brook@trillium.NMSU.Edu, tih@hamartun.priv.no, rkirkpat@nag.cs.colorado.edu, martin@biochemistry.ucl.ac.uk, t-ishii@sra.co.jp, Keith Parks <emkxp01@mtcc.demon.co.uk>, dlw@seavme.xroads.com
Date: 1998-10-25T21:35:16Z
Lists: pgsql-hackers
"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 |