Home Forums SQL Server 2008 T-SQL (SS2K8) Sql Server 2008: Conversion From Text data type to Datetime RE: Sql Server 2008: Conversion From Text data type to Datetime
nigelrivett
SSCertifiable
Points: 5362
More actions
December 11, 2012 at 4:29 am
#1567362
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.
Cursors never.DTS - only when needed and never to control.