Convert Access queries T-SQL
Posted on 2003-02-20
I am trying to convert a date type field form text to date/Time or from nvarchar to datetime.
The field in Access looks like this:
In T-SQL I have something like this
LEFT (Date, 2) + ' /' + LEFT (Date, 4) + ' /' + RIGHT (Date, 2)
First SQL tells me that there is no MID function and second I can not convert from text to datetime and I can not get the middle 2 number to show like: 02/20/03