[geeklog-devel] Actual Working Schema for GL2

Vincent Furia vfuria at gmail.com
Fri Dec 17 08:27:34 EST 2004


Then why not use TIMESTAMPs or DATETIMEs?  Changing the format of a
date/time string is a trivial and fast operation.  Plus using
DATETIMEs allows you to use any date from 1-1-0000 to 12-21-9999 as
opposed to just ~1970 to ~2037.  Both have the same flexibility as
using a timestamp stored as an int, in addition they give you more
flexibility to do calculations on the server using mysql's time
functions.

-Vinny


On Fri, 17 Dec 2004 02:38:15 -0600, Justin Carlson
<justin.carlson at gmail.com> wrote:
> > 2. Why are you using INTs for dates?  Why not TIMESTAMPs or DATETIMEs?
> 
> For mktime() or time() stamps, at least, that's what I like to use.
> Then users can choose whatever they want via a dropdown, allowing them
> to easily set zone and date format.
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-devel
>



More information about the geeklog-devel mailing list