RE: [PEAR-DEV] Re: [metabase-dev] MDB news (http://pear.php.net/package-info.php?package=MDB)
| From: | Lukas Smith | Date: | Wed, 04 Sep 2002 22:19:13 +0000 |
| Subject: | RE: [PEAR-DEV] Re: [metabase-dev] MDB news (http://pear.php.net/package-info.php?package=MDB) | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-8846@lists.php.net to get a copy of this message | ||
> From: Manuel Lemos [mailto:mlemos@acm.org]
> Sent: Wednesday, September 04, 2002 3:47 PM
>
> Anyway, I also noticed that you assume a default for dates that is not
> valid for most databases and even less is portable. 0000-00-00 is a
date
> that never existed. The date count after Christ started in 0001-01-01
.
> The year before 1 is -1, not 0.
>
> Still, even if you assumed 0001-01-01 as default, not all databases
> allow arbitrary ranges of 4 digit years . Some do not allow dates
before
> 1970 or 1900.
I will look into this issue after 1.0 more deeply.
For now I guess its atleast a step in the right direction to rather use
0001-01-01. But it is only relevant for the reverse engineering really
and people will have to manually edit the resulting xml schema file
anyways until further advancements are made (like an interactive
application etc).
Regards,
Lukas