You can call UNIX_TIMESTAMP() on the TIMESTAMP field in your SELECT statement to get that value if you need it. It seems odd to me to sacrifice the convenience of MySQL's time/date functions to make things easier on the PHP side.
-- Matt Mayers [email protected] http://mattmayers.com/ On Sat, May 29, 2010 at 8:30 PM, Travis Paul <[email protected]> wrote: > 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 > >
_______________________________________________ Fwlug mailing list [email protected] http://fortwaynelug.org/mailman/listinfo/fwlug_fortwaynelug.org
