I've just had my first project which involves migrating a MSSQL database into MySQL, and I've just hit my first puzzler (which I'm hoping is something that anyone who performs these migrations regularly will find trivial).
The dates seem to be stored as the equivalent of a UNIX timestamp - values like 38376.51454 and 39406.75522 - and I've searched both Google and CodingForums.com, but to be honest I'm not sure of the terminology, so I'm not sure if I'm searching for the right thing.
I have MSSQL Server Management Studio 2005, am running MySQL 5.0.41 and have the MySQL GUI Tools (although I've not persuaded the Migration Assistant to work) and Navicat, in case there's anything that I can do when actually migrating the data, rather than transforming it after.
Ideally, I'd like the dates stored as MySQL dates, as that would make it easier for me to continue working with the imported data, and create new entries.
Can anyone point me in the right direction?