I am using sql server 2012
This is my sql which works fine in 2008
SELECT distinct NAME,DATE FROM WAYNE_CUSTOMERS
WHERE UP_DT BETWEEN '2013-10-30 18:04:37.880' and '2013-10-30 18:04:37.897'
But in 2012 version i get this error
>>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Any idea how i can fix this?