I have a vb.net project that I converted from Access to SQL Server.
In Access, all of my date/time fields were saved as
The fix to this was to use queries in SQL Server.
ALTER TABLE table_name ADD new_column datetime
SET new_column = old_column
ALTER TABLE DROP old_column
This may also include the need to edit primary keys etc and relationships but these can just be added straight back in again. Finally, rename the new column with the old columns name, and move it into the correct location.