Re: Re: 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 (jon@csh.rit.edu) . Rochester Inst. of Technology http://www.csh.rit.edu/~jon/ : Computer Science House Member