Datetime Conversion error

I hope you are aware thate Convert(DateTime, <SomeValue>, 110) means that you convert into the USA format "mm-dd-yy". The string literal you use has the format "yyyy-mm-dd hh:mi:ss.mmm"

Try Convert(DateTime, <SomeValue>, 121)

This one is defined as "yyyy-mm-dd hh:mi:ss.mmm(24h)"

http://msdn.microsoft.com/en-us/library/ms187928.aspx