Convert Long Date into DateTime???

[tqeonline]

I have the following:

select cast('Friday, September 23, 2011 2:04:00 PM' as datetime)

and it returns an error but if i change it to:

select cast('September 23, 2011 2:04:00 PM' as datetime)

it works... is there a better way to remove the "Friday" or the 'day' from the datetime?

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[tqeonline]

This gives me the expected result, just thought there is an easier way:

declare @strDate as nvarchar(50)
set @strDate = 'Friday, September 23, 2011 2:04:00 PM'
select cast(right(@strDate,len(@strDate)-(CHARINDEX(',',@strDate)+1)) as datetime) as 'Date'

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008