Re: Modification in LiveUser SQL for Perm and Auth

From: Date: Thu, 10 Oct 2002 13:22:49 +0000
Subject: Re: Modification in LiveUser SQL for Perm and Auth
References: 1  Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-9995@lists.php.net to get a copy of this message
Hi again, I forgot to mention one more point about date/time fields. I have noticed that all database support int() fields while they don't support datetime fields the same way. For instance, in MySQL, you will use DATE_FORMAT() while in Oracle, you use TO_CHAR() in your queries. Then, I suggest we use regular unix timestamps as they are very well handled by PHP and its date() function. The drawback is that, as raw data, they are not very much readable except if you naturally know how many seconds have spent since 1 january 1970 :) Any opinions ? Bertrand Mansion Mamasam

« previous php.pear.dev (#9995) next »