|
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 ONGOSET
QUOTED_IDENTIFIER ONGOALTER 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 |
[dbo].[Func_DateFormat],布布扣,bubuko.com
原文：http://www.cnblogs.com/Jenny90/p/3636463.html