Viewing 4 posts - 1 through 4 (of 4 total)
Its a Date Data Type
September 23, 2013 at 3:16 pm
#1652491
Its not working , I got this message :
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
September 23, 2013 at 3:03 pm
#1652487
I don't have a problem to get a random month or a day I just using this :
UPDATE table_a
...
September 23, 2013 at 1:47 pm
#1652463
If I want to select it's working but as I mentioned I'm trying to insert and because my column is a 'date type' when I'm using CONVERT(VARCHAR(7), GETDATE(), 111)-- AS...
September 23, 2013 at 12:43 pm
#1652435