From: | "Billy G(dot) Allie" <Bill(dot)Allie(at)mug(dot)org> |
---|---|
To: | "Thomas A(dot) Szybist" <szybist(at)boxhill(dot)com> |
Cc: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>, Postgres Hackers List <hackers(at)postgreSQL(dot)org>, Postgres Documentation List <docs(at)postgreSQL(dot)org>, geek+(at)cmu(dot)edu, brook(at)trillium(dot)NMSU(dot)Edu, tih(at)hamartun(dot)priv(dot)no, rkirkpat(at)nag(dot)cs(dot)colorado(dot)edu, martin(at)biochemistry(dot)ucl(dot)ac(dot)uk, t-ishii(at)sra(dot)co(dot)jp, Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk>, dlw(at)seavme(dot)xroads(dot)com |
Subject: | Re: [HACKERS] Last call? |
Date: | 1998-10-25 21:35:16 |
Message-ID: | 199810252135.QAA19640@bgalli.mug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(dot)Allie(at)mug(dot)org
| /| | 7436 Hartwell | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)com
|/ |LLIE | (313) 582-1540 |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-10-25 22:53:43 | Re: [HACKERS] Last call? |
Previous Message | Oliver Elphick | 1998-10-25 21:31:23 | Re: [HACKERS] Re: [DOCS] Last call? |