Re: Modification in LiveUser SQL for Perm and Auth

Am Thu, 10 Oct 2002 15:22:49 +0200 schrieb Bertrand Mansion <bmansion@mamasam.com>: > 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 ? Actually, we´ve had regular timestamps at first, but then again decided to do things the MDB way... but the more I think about it, the more I think we should let an MDB container have its own database model, as we won´t have this kind of portability with DB, so we should stick to the lowest common denominator with the DB container... Regards, Markus -- *21st Media* | Consulting, Konzeption, Produktion für die Bereiche: Markus Wolff | Internet, Intranet, eCommerce, Content Management, Hamburg,Germany | Softwareentwicklung, 3D-Animation, Videostreaming http://21st.de | Tel. [+49](0)40/6887949-0, Fax: [+49](0)40/6887949-1