SQLServer CONVERT 函数测试结果

复制代码 代码如下:SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 0State of Qatar: 05 16 贰零零伍 10:57AM SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 1卡塔尔(قطر‎: 05/16/06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 2卡塔尔国: 06.05.16 SELECT
CONVERT(varchar(100), GETDATE(卡塔尔, 3卡塔尔(قطر‎: 16/05/06 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 4卡塔尔国: 16.05.06 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 5卡塔尔: 16-05-06 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 6卡塔尔(قطر‎: 16 05 06 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 7卡塔尔: 05 16, 06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 8卡塔尔国: 10:57:46 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 9卡塔尔: 05 16 二零零五 10:57:46:827AM SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 10State of Qatar: 05-16-06 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 11卡塔尔: 06/05/16 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 12卡塔尔(قطر‎: 060516 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 13卡塔尔国: 16 05 二〇〇七 10:57:46:937 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 14卡塔尔: 10:57:46:967 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 20卡塔尔: 二〇〇五-05-16 10:57:47 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 21State of Qatar: 二零零七-05-16 10:57:47.157 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 22State of Qatar: 05/16/06 10:57:47 AM SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 23State of Qatar: 二〇〇六-05-16 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 24卡塔尔: 10:57:47 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(State of Qatar, 25卡塔尔: 二零零五-05-16 10:57:47.250 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 100卡塔尔国: 05 16 2005 10:57AM SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 101卡塔尔: 05/16/二零零七 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 102State of Qatar: 2005.05.16 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 103卡塔尔国: 16/05/二〇〇七 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 104卡塔尔(قطر‎: 16.05.二零零七 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 105卡塔尔国: 16-05-二零零五 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 106): 16 05 2007 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 107卡塔尔: 05 16, 2007 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 108卡塔尔(قطر‎: 10:57:49 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 109卡塔尔: 05 16 2005 10:57:49:437AM SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 110卡塔尔国: 05-16-二零零六 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 111卡塔尔: 二零零六/05/16 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 112卡塔尔国: 二〇〇七0516 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 113卡塔尔(قطر‎: 16 05 二零零五 10:57:49:513 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 114卡塔尔: 10:57:49:547 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 120卡塔尔(قطر‎: 2005-05-16 10:57:49 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 121卡塔尔国: 二零零五-05-16 10:57:49:513 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 126卡塔尔国: 2005-05-16T10:57:49.827 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 130卡塔尔国: 18 ???? ?????? 1427
10:57:49:907AM SELECT CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(State of Qatar, 131State of Qatar: 18/04/1427
10:57:49:920AM

格式: CONVERT(data_type,expression[,style]) 说明:
此样式日常在岁月档案的次序(datetime,smalldatetimeState of Qatar与字符串类型(nchar,nvarchar,char,varchar卡塔尔国相互转变的时候才用到. 例子:澳门金沙vip, SELECT
CONVERT(varchar(30卡塔尔(قطر‎,getdate(卡塔尔,101卡塔尔国 now 结果为: now
————————————— |09/15/2000Style数字在调换时间时的含义如下: 复制代码
代码如下: Style(2位表示年份State of Qatar | Style(4位代表年份卡塔尔 | 输入输出格 式 0 |
100 | mon dd yyyy hh:miAM(或PM卡塔尔(قطر‎ 1 | 101 U.S. | mm/dd/yy 2 | 102 ANSI |
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
| 109 | mon dd yyyy hh:mi:ss:mmmmAM(或PMState of Qatar 10 | 110 U.S. | mm-dd-yy 11 |
111 东瀛 | yy/mm/dd 12 | 112 ISO | yymmdd 13 | 113 澳大得梅因暗中同意值 | dd mon
yyyy hh:mi:ss:mmm(24 时辰制卡塔尔(قطر‎ 14 | 114 | hh:mi:ss:mmm(24小时制State of Qatar 20 | 120
ODBC 标准 | yyyy-mm-dd hh:mi:ss(24钟头 制卡塔尔 21 | 121 | yyyy-mm-dd
hh:mi:ss:mmm(24钟头 制卡塔尔(قطر‎ 话语及查询结果: 复制代码 代码如下: SELECT CONVERT(varchar(100State of Qatar,
GETDATE(卡塔尔(قطر‎, 0State of Qatar: 05 16 二〇〇七 10:57AM SELECT CONVERT(varchar(100卡塔尔,
GETDATE(State of Qatar, 1State of Qatar: 05/16/06 SELECT CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 2卡塔尔(قطر‎:
06.05.16 SELECT CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 3卡塔尔国: 16/05/06 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 4卡塔尔国: 16.05.06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 5卡塔尔: 16-05-06 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 6卡塔尔(قطر‎: 16 05 06 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 7卡塔尔国: 05 16, 06 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 8卡塔尔: 10:57:46 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 9State of Qatar: 05 16 贰零零伍 10:57:46:827AM SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 10State of Qatar: 05-16-06 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 11State of Qatar: 06/05/16 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 12State of Qatar: 060516 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 13卡塔尔: 16 05 二〇〇六 10:57:46:937 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 14卡塔尔: 10:57:46:967 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 20State of Qatar: 2007-05-16 10:57:47 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 21卡塔尔(قطر‎: 二零零六-05-16 10:57:47.157 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 22卡塔尔: 05/16/06 10:57:47 AM SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 23State of Qatar: 二零零七-05-16 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 24卡塔尔: 10:57:47 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 25卡塔尔(قطر‎: 二〇〇七-05-16 10:57:47.250 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 100卡塔尔: 05 16 二零零五 10:57AM SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 101State of Qatar: 05/16/二零零七 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 102State of Qatar: 二〇〇五.05.16 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 103卡塔尔: 16/05/二〇〇六 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 104卡塔尔: 16.05.2006 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 105卡塔尔: 16-05-二〇〇五 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 106卡塔尔: 16 05 二〇〇六 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 107卡塔尔(قطر‎: 05 16, 二〇〇七 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 108卡塔尔(قطر‎: 10:57:49 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 109卡塔尔: 05 16 二零零七 10:57:49:437AM SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 110卡塔尔(قطر‎: 05-16-2007 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 111卡塔尔(قطر‎: 二〇〇五/05/16 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 112卡塔尔(قطر‎: 二零零五0516 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(State of Qatar, 113State of Qatar: 16 05 二〇〇七 10:57:49:513 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 114卡塔尔(قطر‎: 10:57:49:547 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 120卡塔尔: 二零零六-05-16 10:57:49 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 121卡塔尔: 二零零七 SQL常用到的CONVERT(State of Qatar函数
次次用,次次查,次次忘,干脆记下来。 复制代码 代码如下: SELECT CONVERT(varchar(100State of Qatar,
GETDATE(State of Qatar, 0卡塔尔: 05 16 二零零五 10:57AM SELECT CONVERT(varchar(100卡塔尔国,
GETDATE(State of Qatar, 1卡塔尔国: 05/16/06 SELECT CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 2卡塔尔(قطر‎:
06.05.16 SELECT CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 3卡塔尔国: 16/05/06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 4卡塔尔: 16.05.06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 5卡塔尔(قطر‎: 16-05-06 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 6卡塔尔: 16 05 06 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 7卡塔尔: 05 16, 06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 8State of Qatar: 10:57:46 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 9卡塔尔(قطر‎: 05 16 二〇〇七 10:57:46:827AM SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 10卡塔尔: 05-16-06 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 11State of Qatar: 06/05/16 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 12卡塔尔: 060516 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 13卡塔尔: 16 05 2007 10:57:46:937 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 14State of Qatar: 10:57:46:967 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 20State of Qatar: 二零零六-05-16 10:57:47 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 21卡塔尔国: 2007-05-16 10:57:47.157 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 22卡塔尔: 05/16/06 10:57:47 AM SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 23卡塔尔国: 2007-05-16 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 24卡塔尔国: 10:57:47 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 25卡塔尔(قطر‎: 2006-05-16 10:57:47.250 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(State of Qatar, 100卡塔尔: 05 16 二〇〇六 10:57AM SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 101State of Qatar: 05/16/2007 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 102卡塔尔: 二〇〇七.05.16 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 103卡塔尔(قطر‎: 16/05/贰零零伍 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 104卡塔尔国: 16.05.二零零七 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 105卡塔尔(قطر‎: 16-05-二零零七 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 106卡塔尔(قطر‎: 16 05 二〇〇七 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 107卡塔尔(قطر‎: 05 16, 2007 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 108卡塔尔国: 10:57:49 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 109卡塔尔: 05 16 二零零七 10:57:49:437AM SELECT
CONVERT(varchar(100卡塔尔, GETDATE(State of Qatar, 110卡塔尔: 05-16-二〇〇七 SELECT
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 111卡塔尔(قطر‎: 二零零七/05/16 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 112State of Qatar: 二〇〇六0516 SELECT
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 113卡塔尔(قطر‎: 16 05 2007 10:57:49:513 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 114State of Qatar: 10:57:49:547 SELECT
CONVERT(varchar(100), GETDATE(卡塔尔(قطر‎, 120State of Qatar: 二零零五-05-16 10:57:49 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 121卡塔尔: 2007-05-16 10:57:49.700 SELECT
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 126卡塔尔国: 二〇〇六-05-16T10:57:49.827 SELECT
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 130卡塔尔(قطر‎: 18 ???? ?????? 1427
10:57:49:907AM SELECT CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 131State of Qatar: 18/04/1427
10:57:49:920AM

MS SQL Server汉语版的预设日期datetime格式是yyyy-mm-dd hh:mm:ss.mmm
长短日期格式 复制代码 代码如下:
–短日期格式:yyyy-m-d SELECT
REPLACE(CONVERT(varchar(10卡塔尔,getdate(卡塔尔国,120卡塔尔国,N’-0′,’-‘卡塔尔国–长日期格式:yyyy年mm月dd日 SELECT
STUFF(STUFF(CONVERT(char(8State of Qatar,getdate(State of Qatar,112卡塔尔(قطر‎,5,0,N’年’卡塔尔,8,0,N’月’卡塔尔+N’日’
–短日期格式:yyyy年m月d日 SELECT
DATENAME(Year,getdate(State of QatarState of Qatar+N’年’+CAST(DATEPART(Month,getdate(卡塔尔国卡塔尔国 AS
varchar卡塔尔国+N’月’+DATENAME(Day,getdate(卡塔尔(قطر‎State of Qatar+N’日’
–完全日期+时间格式:yyyy-mm-dd hh:mi:ss:mmm SELECT
CONVERT(char(11卡塔尔,getdate(State of Qatar,120卡塔尔+CONVERT(char(12State of Qatar,getdate(卡塔尔国,114卡塔尔国 CONVERT
复制代码 代码如下: Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 0) : 05 16 二零零六 10:57AM Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 1State of Qatar : 05/16/06 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 2卡塔尔 : 06.05.16 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 3卡塔尔(قطر‎ : 16/05/06 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 4卡塔尔 : 16.05.06 Select
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 5卡塔尔国 : 16-05-06 Select
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 6卡塔尔 : 16 05 06 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 7卡塔尔(قطر‎ : 05 16, 06 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 8卡塔尔国 : 10:57:46 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 9卡塔尔(قطر‎ : 05 16 二〇〇七 10:57:46:827AM Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 10卡塔尔(قطر‎ : 05-16-06 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 11卡塔尔(قطر‎ : 06/05/16 Select
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 12State of Qatar : 060516 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 13卡塔尔(قطر‎ : 16 05 二零零六 10:57:46:937 Select
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 14State of Qatar : 10:57:46:967 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 20卡塔尔 : 二〇〇五-05-16 10:57:47 Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 21State of Qatar : 二〇〇五-05-16 10:57:47.157 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 22卡塔尔 : 05/16/06 10:57:47 AM Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 23卡塔尔 : 2005-05-16 Select
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 24State of Qatar : 10:57:47 Select
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 25卡塔尔国 : 二〇〇七-05-16 10:57:47.250 Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔国, 100卡塔尔(قطر‎ : 05 16 二〇〇七 10:57AM Select
CONVERT(varchar(100卡塔尔国, GETDATE(State of Qatar, 101State of Qatar : 05/16/2007 Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔(قطر‎, 102卡塔尔 : 2007.05.16 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(State of Qatar, 103卡塔尔 : 16/05/2005 Select
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔国, 104State of Qatar : 16.05.二零零七 Select
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 105State of Qatar : 16-05-2007 Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 106卡塔尔国 : 16 05 二〇〇五 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 107State of Qatar : 05 16, 二〇〇六 Select
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔(قطر‎, 108卡塔尔(قطر‎ : 10:57:49 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔(قطر‎, 109State of Qatar : 05 16 二零零五 10:57:49:437AM Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔, 110卡塔尔国 : 05-16-二零零六 Select
CONVERT(varchar(100卡塔尔, GETDATE(卡塔尔, 111卡塔尔(قطر‎ : 二零零七/05/16 Select
CONVERT(varchar(100State of Qatar, GETDATE(State of Qatar, 112State of Qatar : 二〇〇六0516 Select
CONVERT(varchar(100State of Qatar, GETDATE(卡塔尔, 113) : 16 05 二〇〇六 10:57:49:513 Select
CONVERT(varchar(100State of Qatar, GETDATE(), 114卡塔尔(قطر‎ : 10:57:49:547 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 120卡塔尔(قطر‎ : 二〇〇六-05-16 10:57:49 Select
CONVERT(varchar(100卡塔尔国, GETDATE(卡塔尔国, 121State of Qatar : 二〇〇五-05-16 10:57:49.700 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔, 126卡塔尔国 : 二〇〇六-05-16T10:57:49.827 Select
CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔(قطر‎, 130State of Qatar : 18 ???? ?????? 1427
10:57:49:907AM Select CONVERT(varchar(100卡塔尔(قطر‎, GETDATE(卡塔尔国, 131卡塔尔(قطر‎ : 18/04/1427
10:57:49:920AM 得以依附varchar(100State of Qatar 的尺寸做相应的截取。