When there's no time for best practices
DECLARE @test varchar(10) SET @test = '12/31/2011' DECLARE @test_date datetime SET @test_date = CONVERT(datetime, @test, 101)