Create function [dbo].[get_Custome_date]
(
@date datetime = null
)
returns nvarchar(50)
as begin
declare @d int,
@m nvarchar(15),
@y nvarchar(4),
@end nvarchar(1),
@return nvarchar(50)
if @date is null
set @date=getdate()
select @d=datepart(d, @date), @m=datename(m, @date), @Y=
datename(yyyy,@date), @end=right(convert(nvarchar(2), @d),1)
set @return=
convert(nvarchar(2), @d)
+case
when @d in(11, 12, 13) then 'th'
when @end='1' then 'st'
when @end='2' then 'nd'
when @end='3' then 'rd'
else 'th'
end
+' '+@m+' '+@y
return @return
end
======
select dbo.get_Custome_date(getdate()) AS Customedate
Result is
3rd November 2013
(
@date datetime = null
)
returns nvarchar(50)
as begin
declare @d int,
@m nvarchar(15),
@y nvarchar(4),
@end nvarchar(1),
@return nvarchar(50)
if @date is null
set @date=getdate()
select @d=datepart(d, @date), @m=datename(m, @date), @Y=
datename(yyyy,@date), @end=right(convert(nvarchar(2), @d),1)
set @return=
convert(nvarchar(2), @d)
+case
when @d in(11, 12, 13) then 'th'
when @end='1' then 'st'
when @end='2' then 'nd'
when @end='3' then 'rd'
else 'th'
end
+' '+@m+' '+@y
return @return
end
======
select dbo.get_Custome_date(getdate()) AS Customedate
3rd November 2013