1. T-SQL 日期格式转换

由原始的值2012-04-03 10:57:06.127转换成以下20种常用的格式

2012-04-03

20120403

2012.04.03

04/03/2012

03/04/2012

03.04.2012

03-04-2012

03 Apr 2012

Apr 03, 2012

10:57:06

Apr 3 2012

04-03-2012

2012/04/03

20120403

03 Apr 2012

10:57:06:127

2012-4-3

2012年04月03日

2012年4月3日

2012-04-03 10:57:06:127

代码：

1: --由2012-04-03 10:23:10.177转换成2012-04-03

2: SELECT GETDATE() AS Val,Convert(char(11),GETDATE(),120) AS NeedVal

3:

4: --由2012-04-03 10:23:10.177转换成20120403

5: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 112 ) AS NeedVal

6:

7: --由2012-04-03 10:23:10.177转换成2012.04.03

8: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 102 ) AS NeedVal

9: www.2cto.com

10: --由2012-04-03 10:23:10.177转换成04/03/2012 月日年

11: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 101 ) AS NeedVal

12:

13: --由2012-04-03 10:23:10.177转换成03/04/2012 日月年

14: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 103 ) AS NeedVal

15:

16: --由2012-04-03 10:23:10.177转换成03.04.2012 日月年

17: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 104 ) AS NeedVal

18:

19: --由2012-04-03 10:23:10.177转换成03-04-2012 日月年

20: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 105 ) AS NeedVal

21:

22: --由2012-04-03 10:23:10.177转换成03 Apr 2012 日月年

23: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 106 ) AS NeedVal

24:

25: --由2012-04-03 10:23:10.177转换成Apr 03, 2012

26: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 107 ) AS NeedVal

27:

28: --由2012-04-03 10:23:10.177转换成10:44:02

29: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 108 ) AS NeedVal

30:

31: --由2012-04-03 10:23:10.177转换成Apr 3 2012

32: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 109 ) AS NeedVal

33:

34: --由2012-04-03 10:23:10.177转换成04-03-2012

35: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 110 ) AS NeedVal

36:

37: --由2012-04-03 10:23:10.177转换成2012/04/03

38: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 111 ) AS NeedVal

39:

40: --由2012-04-03 10:23:10.177转换成20120403

41: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 112 ) AS NeedVal

42:

43: --由2012-04-03 10:23:10.177转换成03 Apr 2012

44: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 113 ) AS NeedVal

45:

46: --由2012-04-03 10:23:10.177转换成10:45:45:447

47: select GETDATE() AS Val,CONVERT(varchar(12) , getdate(), 114 ) AS NeedVal

48:

49: --由2012-04-03 10:23:10.177转换成2012-4-3

50: SELECT GETDATE() AS Val,REPLACE(CONVERT(varchar(10),GETDATE(),120),N'-0','-') AS NeedVal

51:

52: --由2012-04-03 10:23:10.177转换成2012年04月03日

53: SELECT GETDATE() AS Val,STUFF(STUFF(CONVERT(char(8),GETDATE(),112),5,0,N'年'),8,0,N'月')+N'日' AS NeedVal

54:

55: --由2012-04-03 10:23:10.177转换成2012年4月3日

56: SELECT GETDATE() AS Val,DATENAME(Year,GETDATE())+N'年'+CAST(DATEPART(Month,GETDATE()) AS varchar)+N'月'+DATENAME(Day,GETDATE())+N'日' AS NeedVal

57:

58: --由2012-04-03 10:23:10.177转换成2012-04-03 10:23:10.177