SQL查询日期型数据转换

Question

查询datetime类型数据为:2007-05-18 12:00:12
请问只显示日期,不显示时间:2007-05-18用什么函数呀?

Answer 1

SELECT CONVERT(nchar(10),'2007-05-18 12:00:12',120)

Answer 2

SELECT CONVERT(char(10),'2007-05-18 12:00:12',120)

Answer 3

-------------------------------------------------------------------------------------------------
Style(2位表示年份)  |  Style(4位表示年份)  |  输入输出格式
-------------------------------------------------------------------------------------------------
-  |     0 or 100  |   mon dd yyyy hh:miAM(或PM)
-------------------------------------------------------------------------------------------------
1  | 101 | mm/dd/yy
-------------------------------------------------------------------------------------------------
2 | 102 | yy.mm.dd
-------------------------------------------------------------------------------------------------
3 | 103 | dd/mm/yy
-------------------------------------------------------------------------------------------------
4 | 104 | dd.mm.yy
-------------------------------------------------------------------------------------------------
5 | 105 | dd-mm-yy
-------------------------------------------------------------------------------------------------
6 | 106 | dd mon yy
-------------------------------------------------------------------------------------------------
7 | 107 | mon dd,yy
-------------------------------------------------------------------------------------------------
8 | 108 | hh:mm:ss
-------------------------------------------------------------------------------------------------
- | 9 or 109 | mon dd yyyy hh:mi:ss:mmmmAM(或PM)
-------------------------------------------------------------------------------------------------
10 | 110 | mm-dd-yy
-------------------------------------------------------------------------------------------------
11 | 111 | yy/mm/dd
-------------------------------------------------------------------------------------------------
12 | 112 | yymmdd
-------------------------------------------------------------------------------------------------
- | 13 or 113 | dd mon yyyy hh:mi:ss:mmm(24小时制)
-------------------------------------------------------------------------------------------------
14 | 114 | hh:mi:ss:mmm(24小时制)
-------------------------------------------------------------------------------------------------
- | 20 or 120 | yyyy-mm-dd hh:mi:ss(24小时制)
-------------------------------------------------------------------------------------------------
- | 21 or 121 | yyyy-mm-dd hh:mi:ss:mmm(24小时制)
-------------------------------------------------------------------------------------------------