How do I to convert varchar datatype to datetime

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » How do I to convert varchar datatype to...

How do I to convert varchar datatype to datetime

Rate Topic

Display Mode

Topic Options

Author

Message

leonie6214

Posted Sunday, August 05, 2012 1:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:54 PM
Points: 38, Visits: 220

Does anyone know how to convert varchar datatype to datetime in TSQL?

Post #1340245

SomewhereSomehow

Posted Sunday, August 05, 2012 6:59 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 27, 2013 8:32 AM
Points: 75, Visits: 412

CAST and CONVERT (Transact-SQL)
Is there any problem with that?

I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
Blog: http://somewheresomehow.ru
Twitter: @SomewereSomehow

Post #1340263

J Livingston SQL

Posted Sunday, August 05, 2012 7:07 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 1,469, Visits: 14,561

leonie6214 (8/5/2012)

Does anyone know how to convert varchar datatype to datetime in TSQL?

please give example of what you want to convert

__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________

Post #1340264

bitbucket-25253

Posted Sunday, August 05, 2012 7:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 5,121, Visits: 20,359

As previously stated you can use CAST or CONVERT. But like many items in T-SQL "It depends". As an example ... be aware of your system date format, and of course the format of the actual data.

DECLARE @T VARCHAR(40)
   SET DATEFORMAT dmy
   SET @T = '2012-08-05 09:13:50.053'
   SELECT CAST(@T AS DATETIME)
   SET @T = '20120805 09:13:50.053'
   SELECT CAST(@T AS DATETIME)
Results:
2012-05-08 09:13:50.053
2012-08-05 09:13:50.053

As is obvious the results are dramatically different. If you would post a sample of your actual data, and your systems dateformat someone may be able to assist you furter.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1340269

« Prev Topic | Next Topic »

Permissions