hello again, used isdate and discovered that there were entries that were not dates 00000000. Filter the 0's and used the cast function but am...
thanks to all. I am going to use the isdate (thinking there are some entries that are not actual dates). I am really a newbie but will search for...
thanks much ... tried everything but still getting the same error. Not sure why this is happening but I need to convert this from nvarchar to...
The data type is nvarchar and the date is entered as 01012007 (mmddyyyy). I'd like to change this to show a date format of 01/01/2007. Tried using...
thanks for responding so quickly. I tried Cast([DATE-OF-SVC] AS DATETIME and still getting the same error: Arithmetic overflow error converting...
I am working with a table that stores a date as nvarchar, 01012007, and would like to convert to smalldatetime, 01/01/2007. Using the following in...
Separate names with a comma.
