(MYSQL) Converting a populated column of datetime to timestamp
 

Hey i have a column in my DB thats a datetime i need to convert all the records on mass to a timestamp.

ive got well over 2500 records like this so going through them one by one is not an option.

anyone able to help me with a php script that when run would convert them to timestamp?

i need to convert a subscription addon for another forum software to VB and this is the only thing that wont match

Any help much appreciated

Dub

you would probably enjoy this function:
http://us2.php.net/mktime

You'll have to break your datetime's apart using explode() or something, but you can construct your actual timestamps using mktime()

What is the columntype of the old database, and please provide some example values.

Also see:
http://dev.mysql.com/doc/refman/4.1/en/datetime.html
http://dev.mysql.com/doc/refman/4.1/...functions.html