date formats migrating from another system, help! man down!

hey everyone!

i just recently successfully used some great data services to move all of the tables from a Microsoft SQL 2000 database to a fresh MySQL database.

I started with ImpEx, and used that to move the users and forums, I used a MySQL frontend GUI to move the threads and posts.

Everything worked pretty good but I have one concern, the timestamps on all of the posts now read 12-31-1969...

The Microsoft SQL table that had timestamps formatted the data as MM-DD-YYYY HH:MM

The MySQL table has a data type named "dateline", and vBulletin generates this random string of numbers for a timestamp..

Anyone know what I can do? Is there a method to this random number that gets generated in MySQL when a timestamp is created?

Thank you so much in advance!

Michael

 

::crickets::

 

The number isn't random I believe vBulletin uses Unix time write a script to convert the standard MMD:YYYY HH:MM to Unix time and reimport.