Re: [PHP] convert mysql datetime to unix timestamp

Chris Hayes (SENSE) wrote: i have to move data from a table with a datetime (2003-05-14 13:36:04) to a unix timestamp (e.g. 2147483647) . Any ideas? ALTER TABLE Table ADD COLUMN unix_time_column INT; UPDATE Table SET unix_time_column = UNIX_TIMESTAMP(mysql_time_column); -- ---John Holmes... Amazon

Re: [PHP] convert mysql datetime to unix timestamp

<[EMAIL PROTECTED]> Chris Hayes (SENSE): > hi, > i have to move data from a table with a datetime (2003-05-14 > 13:36:04) to a unix timestamp (e.g. 2147483647) . Any ideas? > > Chris strtotime(); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.p

Re: [PHP] convert mysql datetime to unix timestamp

Tried passing it through strtotime? Example: echo(date('U',strtotime($string))); On Mon, 2003-07-28 at 12:06, Chris Hayes (SENSE) wrote: > hi, > i have to move data from a table with a datetime (2003-05-14 13:36:04) to a > unix timestamp (e.g. 2147483647) . Any ideas? > > Chris -- Adam Voigt