date conversion 1

[KENDIGIT]

Hi; I'm trying to get a datetime field converted to a
MMDDYY format.
I'm trying to use the

Convert(varchar(6), Birthdate,12)

This gives it to me as YYMMDD. I can't seem to find a way to convert it, except to
use the substring command to pull the pieces. Any idea's?

Thanks
Ken

 

[aneesahmed]

select convert(varchar(20),getdate(),101)

try this out

 

[ClaireHCM]

select replace(convert(varchar,dates,1),'/','') from a
or
select replace(convert(varchar,dates,10),'-','') from a