Date Conversion - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Date Conversion

Author

Topic

bh0526
Yak Posting Veteran

71 Posts

Posted - 2011-08-08 : 11:32:16

How do I convert:

Wednesday, August 31, 2011 to 2011-08-31?

Thanks,

Bob

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2011-08-08 : 11:49:06

There has to be a better way than this

select  convert(varchar(10),convert(datetime
                      ,substring('Wednesday, August 31, 2011',charindex(',','Wednesday, August 31, 2011'
                                                        )+1
                                  ,50
                                 )
               )
     ,121)

Jim

Everyday I learn something that somebody else already knew

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-08-08 : 11:52:32

declare @date varchar(100)
set @date ='Wednesday, August 31, 2011'
select cast(SUBSTRING(@date,charindex(',',@date)+1,len(@date)) as date)

Madhivanan

Failing to plan is Planning to fail

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2011-08-08 : 11:56:03

Ahh, SQL 2008! I shold've waited a few minutes.

Jim

Everyday I learn something that somebody else already knew

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-08-08 : 12:01:49

quote:
Originally posted by jimf

Ahh, SQL 2008! I shold've waited a few minutes.

Jim

Everyday I learn something that somebody else already knew

Madhivanan

Failing to plan is Planning to fail

bh0526
Yak Posting Veteran

71 Posts

Posted - 2011-08-08 : 13:27:58

Thanks!!

quote:
Originally posted by madhivanan

declare @date varchar(100)
set @date ='Wednesday, August 31, 2011'
select cast(SUBSTRING(@date,charindex(',',@date)+1,len(@date)) as date)

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources