Re: Date fields usage with DB
| From: | Martin Jansen | Date: | Tue, 21 May 2002 14:53:57 +0000 |
| Subject: | Re: Date fields usage with DB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-1417@lists.php.net to get a copy of this message | ||
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.
- Martin