How to convert timestamp to unix time?

[usbnuts]

I have a bunch of data stored via timestamp(14) format. eg. 20010913000000.

I was wondering how to convert all those timestamps to unix time int(10) 999556552. I want to convert the current data to vBulletin mySQL database.

$dateposted = date("D j M Y, g:i A",$dateline);

Thanks!

[Kier]

SELECT yourTable.*, [color=navy][b]UNIX_TIMESTAMP([/b][/color]yourTable.[i]timeStampField[/i][color=navy][b])[/b][/color] AS unixtime FROM yourTable;

This will return all of your table's fields, plus a special 'unixtime' field that represents the unix timestamp of the timestamp field you use.

[usbnuts]

Got it!

You are good!

[Kier]