SQL convert 用法 CONVERT(data_type,expression[,style]) convert(varchar(10),欄位名,轉換格式) 說明: 此樣式一般在時間型別(datetime,smalldatetime)與字串型別(nchar,nvarchar,char,varchar) 相互轉換的時候才用到. 例子: SELECT CONVERT(varchar(30),getdate(),101) now 結果為: now --------------------------------------- |09/15/2001 =================================================================== style數字在轉換時間時的含義如下: ------------------------------------------------------------------------------------------------------------ Style(2位表示年份) | Style(4位表示年份) | 輸入輸出格式 ------------------------------------------------------------------------------------------------------------ 0 | 100 | mon dd yyyy hh:miAM(或PM) ------------------------------------------------------------------------------------------------------------ 1 | 101 美國 | 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(或PM) ------------------------------------------------------------------------------------------------------------ 10 | 110 美國 | 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小時制) ------------------------------------------------------------------------------------------------------------ 20 | 120 ODBC 規範 | yyyy-mm-dd hh:mi:ss(24小時制) ------------------------------------------------------------------------------------------------------------ 21 | 121 | yyyy-mm-dd hh:mi:ss:mmm(24小時制) ------------------------------------------------------------------------------------------------------------