Hey all, I've tended to store dates as a simple epoch integer (seconds from Jan, 1970), a throwback to perl/tcl/php development days. While this method is a little antiquated, it makes the dates database and software independent. CF, perl, php, database upgrade, whatever... can and will handle these integers fine (well, until 2038).
However, I suspect that some of the mysql date/time datatypes and functions offer some serious functionality and time saving improvements. So I'm just wondering what's considered the current best practice use of date and time storage in mysql using CF. Timestamp? Datetime? Neither? Is using epoch times a no-no nowadays, or do other people still use it? Regards, Terry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
