Re: Modification in LiveUser SQL for Perm and Auth
| From: | Bertrand Mansion | 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