Re: Date fields usage with DB
| From: | Stig S. Bakken | Date: | Tue, 21 May 2002 15:34:34 +0000 |
| Subject: | Re: Date fields usage with DB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-1419@lists.php.net to get a copy of this message | ||
On Tue, 2002-05-21 at 16:53, Martin Jansen wrote:
> On Tue, 21 May 2002 16:46:10 +0200, Nicolas Hoizey wrote:
>
> >I wonder if anybody has already established a list of cross db field
> >types and functions.
> >
> >Here are the main usages I will have :
> >
> >- dates possibly before 1970 and after 2038
> >- usual dates manip: add, sub, interval, etc
> >- "fuzzy" dates: 2002-10-00 for october 2002 for example
> >- system date and time: "now()" in MySQL, "now" in PostgreSQL, etc
> >- ...
>
> I suppose that Metabase (http://www.phpclasses.org) is the tool of your
> preference, since it actually should support such emulations.
>
> Right now, PEAR::DB can't do that job for you.
You could try MDB, which is a merge of DB and Metabase currently in
testing: "pear install MDB".
- Stig