Justin Giboney wrote:
I should have designed the db using a date field (or even better a
long integer with unix timestamp), but I didn't plan well, and now I
suffer.
Justin Giboney
I avoid unix timestamp for database time/date data. A few reasons:
* I like to see the date in a readable format up-front.
* One less function - you don't need to convert the date from unix
timestamp to date format
* Unless I'm mistaken, Unix Timestamp fields cannot precede January 1,
1970. Some movies are older than that.
In addition, I'm considering migrating some information away from
standard date-time fields to just the way you have done it. $this,
because these fields also have constraints. Consider a geneological
database - I can't use a standard MySQL date/time field to record births
1,000 years ago.
Brandon Stout
http://mscis.org
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
