After transferring data from Access to SQL - how to get date and time fields formatted and look exactly as they had in Access?
Posted on 2013-05-31
Please note Image 1 that shows Start Date, End Date, Start Time and End Time and their values directly from the table as formatted.
In Image 2, this is how SQL Server has the data formatted within after using Microsoft SQL Server Migration Assistant for Access.
I need the SQL Server data to be formatted exactly as shown in Access.
I've tried changing the date type fields and then running the update query but the data value do not change.
Should I just change it to text as the data type values?