ALTER Function [dbo].[FormatDateNew] (@Format nvarchar(60),@date datetime)
RETURNS varchar(60) AS
BEGIN
if @Format='yyyy'
select @Format= year(@date)
if @Format='MMddyy'
select @Format=replace(CONVERT(varchar(100), @date, 1),'/','')
if @Format='ddMMyyyy'
select @Format= REPLACE(CONVERT(varchar(100), @date, 106),' ','')
if @Format='ddMMyy'
select @Format= substring( REPLACE(CONVERT(varchar(100), @date, 106),' ',''),0,5)+substring( CONVERT(varchar(100), year(@date)),3,3)
if @Format='yyyyMMdd'
select @Format= REPLACE(CONVERT(varchar(100), GETDATE(), 23),'-','')
if @Format='yy'
select @Format= substring( CONVERT(varchar(100), year(@date)),3,3)
if @Format='yyMM'
select @Format=left( CONVERT(varchar(100), @date, 12),4)
if @Format='yyMMdd'
select @Format=CONVERT(varchar(100), @date, 12)
if @Format='MMyyyy'
select @Format=replace(substring( CONVERT(varchar(100), @date, 105) ,4, len(CONVERT(varchar(100), @date, 105))),'-','')
if @Format='MMyy'
select @Format=replace(right( CONVERT(varchar(100), @date, 3),5),'/','')
if @Format='MMddyyyy'
select @Format=replace(CONVERT(varchar(100), @date, 101),'/','')
if @Format='yyyyddmm'
select @Format=CONVERT(varchar(100), @date, 112)
return @Format
END