首頁 >資料庫 >mysql教程 >M$SQL convert(...)

M$SQL convert(...)

WBOY
WBOY原創
2016-06-07 14:57:151037瀏覽

M$SQL转换日期时间为字符串函数convert中的格式代码与其输出格式的应对 无 /*fmt,strdt1,07/03/132,13.07.033,03/07/134,03.07.135,03-07-136,03 07 137,07 03, 138,09:40:589,07 3 2013 9:40:58:043AM10,07-03-1311,13/07/0312,13070313,03 07 2013 09:40:58

M$SQL转换日期时间为字符串函数convert中的格式代码与其输出格式的应对
/*
fmt,strdt
1,07/03/13
2,13.07.03
3,03/07/13
4,03.07.13
5,03-07-13
6,03 07 13
7,07 03, 13
8,09:40:58
9,07  3 2013  9:40:58:043AM
10,07-03-13
11,13/07/03
12,130703
13,03 07 2013 09:40:58:043
14,09:40:58:043
20,2013-07-03 09:40:58
21,2013-07-03 09:40:58.043
22,07/03/13  9:40:58 AM
23,2013-07-03
24,09:40:58
25,2013-07-03 09:40:58.043
100,07  3 2013  9:40AM
101,07/03/2013
102,2013.07.03
103,03/07/2013
104,03.07.2013
105,03-07-2013
106,03 07 2013
107,07 03, 2013
108,09:40:58
109,07  3 2013  9:40:58:043AM
110,07-03-2013
111,2013/07/03
112,20130703
113,03 07 2013 09:40:58:043
114,09:40:58:043
120,2013-07-03 09:40:58
121,2013-07-03 09:40:58.043
126,2013-07-03T09:40:58.043
127,2013-07-03T09:40:58.043
130,25 ????? 1434  9:40:58:043AM
131,25/08/1434  9:40:58:043AM
*/
陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn