How do I to convert varchar datatype to datetime

Question

Post reply

How do I to convert varchar datatype to datetime

leonie6214

SSC Eights!

Points: 989
More actions
August 5, 2012 at 1:54 am

#260423

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SomewhereSomehow SSCommitted Points: 1586 More actions · Answer 1

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[/url]
Twitter: @SomewereSomehow

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

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
and remember....every day is a school day

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

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[/url]
Before posting a performance problem please read[/url]