During the process of migrating a SQL Server database to MySQL I came across the problem of how to handle a SQL Server CAST() function for type SmallDateTime. I was supplied with a SQL dump of the original database and proceeded to write a Windows C# conversion program. The resulting SQL was then imported into the destination MySQL database. There is a lot of good information of converting the various field types, but it was difficult to get the complete picture on how to handle the CAST() function for the SmallDataTime type.
