I am migrating a Access database over to SQL, The dates in access were stored as Strings, whereas the SQL table they are moving into are the Datetime Format.
When i try the insert Function i get the error message below
What is the easiest way to change the format,
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
i have read about the Convert function but dont fully understand this.
When i try the insert Function i get the error message below
What is the easiest way to change the format,
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
i have read about the Convert function but dont fully understand this.