nigelrivett (12/11/2012)
Are you sure that is causing the problem?This should work
select convert(datetime, 'Jul 21 2010 10:15AM')
Could be due to your settings maybe.
The question and topic title say they are converting from TEXT to DATETIME, you cannot convert TEXT directly to DATETIME, you have to do an implicit conversion to VARCHAR then to DATETIME