Thanks Matt, But I'd really like to store most of my date values as int(10), as unix time is the easiet to format with php's date() function. Most of my date values are after 1969 and int(10) is the most efficient way to store the dates. If I store my dates as TIMESTAMP I'll have to call strtotime() on each value.
On May 29, 2010 8:23 PM, "Matt Mayers" <[email protected]> wrote: If you have a column type of TIMESTAMP, you can set DEFAULT CURRENT_TIMESTAMP to achieve this. However, keep in mind that all values are converted from the machine's local time to UTC before being stored in a TIMESTAMP field and automatically converted back to local time when retrieved. http://dev.mysql.com/doc/refman/5.0/en/timestamp.html -- Matt Mayers [email protected] http://mattmayers.com/ On Sat, May 29, 2010 at 6:53 PM, Travis Paul <[email protected]> wrote: > > I think you're righ... _______________________________________________ Fwlug mailing list [email protected] http://fortwaynelug.org/mailman/listinfo/fwlug_fortwaynelug.org
_______________________________________________ Fwlug mailing list [email protected] http://fortwaynelug.org/mailman/listinfo/fwlug_fortwaynelug.org
