|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
USE [DB]GO/****** Object: UserDefinedFunction [dbo].[Func_DateFormat] Script Date: 03/31/2014 18:08:47 ******/
SET
ANSI_NULLS ON
GOSET
QUOTED_IDENTIFIER ON
GOALTER function [dbo].[Func_DateFormat]
(@Date
datetime, @Format varchar(50))
returns
varchar(11)
asbegin declare
@Month varchar(3)
declare
@MonthInt int
declare
@Day int
declare
@Year int
set
@MonthInt=datepart(mm,@Date)
set
@Day=datepart(dd,@Date)
set
@Year=datepart(yy,@Date)
set
@Month=
case
@MonthInt
when
1 then ‘Jan‘
when
2 then ‘Feb‘
when
3 then ‘Mar‘
when
4 then ‘Apr‘
when
5 then ‘May‘
when
6 then ‘Jun‘
when
7 then ‘Jul‘
when
8 then ‘Aug‘
when
9 then ‘Sep‘
when
10 then ‘Oct‘
when
11 then ‘Nov‘
when
12 then ‘Dec‘
end
if(Upper(@Format)=‘MMM YYYY‘)
begin
return
@Month+‘ ‘+ltrim(@Year)
end
if(Upper(@Format)=‘DD/MMM/YYYY‘)
begin
return
right((‘0‘+ltrim(@Day)),2)+‘/‘+@Month+‘/‘+ltrim(@Year)
end
if(Upper(@Format)=‘DD MMM YYYY‘)
begin
return
right((‘0‘+ltrim(@Day)),2)+‘ ‘+@Month+‘ ‘+ltrim(@Year)
end
if(Upper(@Format)=‘MMM/YYYY‘)
begin
return
@Month+‘/‘+ltrim(@Year)
end
return
convert(varchar(20), @Date, 25)
end |