InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 10:03:25 GMT20http://www.sqlservercentral.com/Forums/Topic1395028-392-1.aspx[quote][b]Teee (12/11/2012)[/b][hr]Thanks for the link and the example posted above works perfectly. :-)[/quote]Happy to helpTue, 11 Dec 2012 04:41:06 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1395028-392-1.aspxThanks for the link and the example posted above works perfectly. :-)Tue, 11 Dec 2012 04:39:46 GMTTeeehttp://www.sqlservercentral.com/Forums/Topic1395028-392-1.aspx[quote][b]nigelrivett (12/11/2012)[/b][hr]Are you sure that is causing the problem?This should workselect convert(datetime, 'Jul 21 2010 10:15AM')Could be due to your settings maybe.[/quote]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 DATETIMETue, 11 Dec 2012 04:31:32 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1395028-392-1.aspxAre you sure that is causing the problem?This should workselect convert(datetime, 'Jul 21 2010 10:15AM')Could be due to your settings maybe.Tue, 11 Dec 2012 04:29:37 GMTnigelrivetthttp://www.sqlservercentral.com/Forums/Topic1395028-392-1.aspxConvert to VARCHAR then convert to datetime.CONVERT(DATETIME,CONVERT(VARCHAR,vchValue))The following link details what can and cannot be converted[url]http://msdn.microsoft.com/en-us/library/ms187928.aspx[/url]Tue, 11 Dec 2012 04:28:38 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1395028-392-1.aspxHi All, How do I convert a text data type column to datetime?The query below returns this error: Explicit conversion from data type text to datetime is not allowed.SELECT CONVERT(DATETIME, vchValue) FROM dtlConfiguration WHERE vchParameter = 'LastRTADImport'The data in 'vchValue' column is in this format: 'Jul 21 2010 10:15AM'RegardsTeeeTue, 11 Dec 2012 04:25:26 GMTTeee