Unix/Date formats conversion

[bachx]

I have a date format of YYYY/MM/DD for some dates stored in my database. I want to create a php script that reads this format and converts it to the Unix format. Any help? Thanks.

[Wildbug]

http://us.php.net/manual/en/function.strtotime.php

 

Or, if your database is MySQL, create a new column and populate it with the following:

 

UPDATE table SET new_ts_col = UNIX_TIMESTAMP(STR_TO_DATE(datecolumn,'%Y/%m/%d'));

 

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date