MySQL date fields -> SQL Server
I have been given a text file that contains a database dump of a MySQL database. Basically, the file contains Create Table statements and Insert Into statements.
I need to import everything into SQL Server however, there are several syntax differences. I figured out all the differences except for Date fields.
All the Create Table statements declare Date fields as int(20). I would like to convert these to SQL Server DateTime fields. Thats not a problem but the Insert statements contain values such as 1038632400, 1030334400 etc..
Through trial and error these values look to be the number of seconds since 01-Jan-1970.
I have no experience with MySQL and just have this text file to work with.
Can anyone verify that this is how MySQL stores date fields or was this just created by the former DBA?
Thanks