Topic: At date change swears
Prompt please in what there can be a reason. The request works, all correctly displays, but at change of date in the filter starts to produce
Msg 8114, Level 16, State 5, Line 2
Error converting data type varchar to float.
Warning: Null value is eliminated by an aggregate or other SET operation.
I can not understand in what the reason
on [tab2]. [HOLEID] = [DRILLINGDETAIL]. [HOLEID] where [DRILLINGDETAIL]. [PROJECTCODE] = ' uz' and cast ([DRILLINGDETAIL]. [DRILLINGDATE] as date) =' 27-oct-2017'
as soon as instead of October, 27th I put for example on July, 15th, produces the code about an error