>> QUOTENAME (cast(DOB as varchar(254)),'"') AS DOB, >>>>
>>"Nov 14 1965 12:00AM" >>>>
>>"19651114" >>>
>DECLARE @test DateTime >SET @TEst = GETDATE() > >SELECT CONVERT(varchar(8),@Test,112) >I tried this:
QUOTENAME (CONVERT(varchar(8),DOB,112)),'"') AS DOB,But got this error:
Msg 102, Level 15, State 1, Line 14 Incorrect syntax near ')'.DOH! Extra parenthesis. Sorry!