Re: [PHP-PEAR] Re: [PHP-CVS] cvs: php4 /pear/Cache/Container db.php

On Fri, Mar 02, 2001 at 10:51:41AM -0500, Chuck Hagenbuch wrote:

> > I was under the impression that 'timestamp' was a standard SQL field
> > type.  At least, it appears to be under the SQL99 standard.
> > 
> > Ref: http://www.comptechnews.com/~reaster/sql99-syntax.txt
> 
> How many db's actually support SQL99, though? I was under the impression that 
> SQL92 support was still kind of dodgy in some cases...

Ah.  A quick search turned up this:

    http://www.postgresql.org/mhonarc/pgsql-general/2000-02/msg00427.html

So, it looks like 'timestamp' is a safe type to use (although there's
really no problem storing a Unix timestamp, either).

-- 
Jon Parise ([email protected])  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member