I converted to varchar(23) becuase I counted 23 characters in your datetime value example (date + time). If you just want the date you can strip out the time...

Maxer (10/16/2009)

---

Why does this fail?

I must be having a slow day today, because I am not seeing my error here...

FAILS:

SELECT CounterDateTime, CONVERT(DATETIME,[CounterData].[CounterDateTime], 121)

FROM [Counterdata]

WORKS:

SELECT CONVERT(DATETIME, '2009-10-15 22:24:40.465', 121)

What am I...