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.
| Author |
Topic |
|
Eagleman
Starting Member
2 Posts |
 Posted - 2010-02-25 : 09:17:00
|
| Guys,I've been googling the last few hours to get an answer to my problem,but can't find it:How to convert 'Monday, December 04, 2009' to a date?Eagleman |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-25 : 09:26:34
|
| [code]SELECT CONVERT(datetime,STUFF('Monday, December 04, 2009',1,CHARINDEX(',','Monday, December 04, 2009'),''),107)[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Eagleman
Starting Member
2 Posts |
Posted - 2010-02-25 : 09:34:50
|
| Thanx. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-25 : 09:40:13
|
welcome  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
String to DateTime conversion