This is just an example:
SELECT * FROM A.B where B_DATE='19-05-2016 12.00.00.000000000 AM';
I always get an error:
Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string.#
I have looked at trying to use
CONVERT, but I can't see any format that matches the datetime format I have above. Any advice on how I can rectify this?