Converting string to datetime format

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » Converting string to datetime format

Converting string to datetime format

Rate Topic

Display Mode

Topic Options

Author

Message

david-1035471

Posted Thursday, April 23, 2009 8:03 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:53 AM
Points: 18, Visits: 95

Hi,

I´m hoping somebody can help with this. I need to convert a set of dates (in string format) to the datetime data type.

The data is currently stored as strtings in the following format:

Monday, January 28, 2008

Thanks in advance

Post #703222

WayneS

Posted Thursday, April 23, 2009 8:38 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 6,367, Visits: 8,228

Try this:

declare @testdate varchar(50), @realdate datetime
set @testdate = 'Monday, January 28, 2008'
set @realdate = SUBSTRING(@testdate, CharIndex(', ', @testdate)+2, 50)
select @testdate, @realdate

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #703259

GSquared

Posted Thursday, April 23, 2009 8:43 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

Please don't double-post in multiple forums.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #703268

WayneS

Posted Thursday, April 23, 2009 8:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 6,367, Visits: 8,228

Ahh, didn't consider double-posting. I thought that I had posted that reply, but then I second-guessed myself and figured that I just didn't click the post button...

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Post #703273

GSquared

Posted Thursday, April 23, 2009 9:03 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

Sorry, wasn't aiming that comment at you, Wayne. Was meant for the OP.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #703300

david-1035471

Posted Friday, April 24, 2009 4:44 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:53 AM
Points: 18, Visits: 95

Hi GSquared,

I did try to delete my first post so as not to double post, but it wouldn´t let me.

Cheers

David

Post #703838

« Prev Topic | Next Topic »

Permissions