declare @String varchar(50) = 'Mon Jan 28 11:03:06 EST 2013'

select cast(left(right(@String, len(@String) - 4), 16) + right(@String, 4) as DateTime)

select
    convert(varchar(20), cast(stuff(substring(string, 5, 15), CHARINDEX(':', substring(string, 5, 15)) - 3, 0, RIGHT(string, 5)) as datetime), 120)    
from (
    select 'Mon Jan 28 11:03:06 EST 2013' as string union all
    select 'Mon Jan 8 11:03:06 EST 2013'
) as test_data

SELECT
    ...other_columns...
    CONVERT(varchar(20), CAST(STUFF(SUBSTRING(fromdate, 5, 15), 
        CHARINDEX(':', substring(fromdate, 5, 15)) - 3, 0, RIGHT(fromdate, 5)) as datetime), 120) AS from_date,
    CONVERT(varchar(20), CAST(STUFF(SUBSTRING(todate, 5, 15), 
        CHARINDEX(':', substring(todate, 5, 15)) - 3, 0, RIGHT(todate, 5)) as datetime), 120) AS to_date,
    ...other_columns...
FROM dbo.tablename
--INNER JOIN ...
WHERE ...