I have the following
2009/12/11 01:35:58.347000 in varchar/string variable.
I need the time part or both date &time as DATETIME,So that i can compare this with current datetime.
Could any one let me know how to convert this string to DATETIME.
I tried using COVERT() function,doesn't work.I got the following error message
"Conversion failed when converting datetime from character string'.