From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Dave Stewart <dstewart(at)aquaflo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Date and Time or Timestamp? |
Date: | 2003-04-30 00:31:42 |
Message-ID: | 200304291731.42143.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dave,
> On CMD's Practical Postgres page
> <http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x2632%2ehtm>,
> Table 3-14 claims a timestamp has a range of 1903AD to 2037AD.
Not at all correct, at least since 7.2.x:
staffos=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.2.4 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)
staffos=# select '2099-09-27'::TIMESTAMP;
timestamptz
---------------------
2099-09-27 00:00:00
(1 row)
staffos=# select '2099-09-27'::TIMESTAMP + '30 days'::INTERVAL;
?column?
---------------------
2099-10-27 00:00:00
(1 row)
staffos=# select '2999-09-27'::TIMESTAMP + '30 days'::INTERVAL;
?column?
---------------------
2999-10-27 00:00:00
(1 row)
staffos=# select '8999-09-27'::TIMESTAMP + '30 days'::INTERVAL;
?column?
---------------------
8999-10-27 00:00:00
(1 row)
I'll admit to not having tested 90,000 AD, but I think we can live with a Y10K
bug, don't you?
--
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-30 04:48:04 | Re: Date and Time or Timestamp? |
Previous Message | Dave Stewart | 2003-04-30 00:15:01 | Date and Time or Timestamp? |