_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › NewDataType-讌蟯
DECLARE @D0 datetime2(0) = '2008-05-10 06:59:11.1234567';
DECLARE @D1 datetime2(1) = '2008-05-10 06:59:11.1234567';
DECLARE @D2 datetime2(2) = '2008-05-10 06:59:11.1234567';
DECLARE @D3 datetime2(3) = '2008-05-10 06:59:11.1234567';
DECLARE @D4 datetime2(4) = '2008-05-10 06:59:11.1234567';
DECLARE @D5 datetime2(5) = '2008-05-10 06:59:11.1234567';
DECLARE @D6 datetime2(6) = '2008-05-10 06:59:11.1234567';
DECLARE @D7 datetime2(7) = '2008-05-10 06:59:11.1234567';
PRINT @D0;
PRINT @D1;
PRINT @D2;
PRINT @D3;
PRINT @D4;
PRINT @D5;
PRINT @D6;
PRINT @D7;

/*
2008-05-10 06:59:11
2008-05-10 06:59:11.1
2008-05-10 06:59:11.12
2008-05-10 06:59:11.123
2008-05-10 06:59:11.1235
2008-05-10 06:59:11.12346
2008-05-10 06:59:11.123457
2008-05-10 06:59:11.1234567
*/

DECLARE @T0 time(0) = '16:59:11.1234567';
DECLARE @T1 time(1) = '16:59:11.1234567';
DECLARE @T2 time(2) = '16:59:11.1234567';
DECLARE @T3 time(3) = '16:59:11.1234567';
DECLARE @T4 time(4) = '16:59:11.1234567';
DECLARE @T5 time(5) = '16:59:11.1234567';
DECLARE @T6 time(6) = '16:59:11.1234567';
DECLARE @T7 time(7) = '16:59:11.1234567';
PRINT @T0;  
PRINT @T1;  
PRINT @T2;  
PRINT @T3;  
PRINT @T4;  
PRINT @T5;  
PRINT @T6;  
PRINT @T7;
/*
16:59:11
16:59:11.1
16:59:11.12
16:59:11.123
16:59:11.1235
16:59:11.12346
16:59:11.123457
16:59:11.1234567
*/

DECLARE @D DATETIMEOFFSET = '2008-05-10 06:59:11.1234567';
DECLARE @D0 DATETIMEOFFSET(0) = '2008-05-10 06:59:11.1234567';
DECLARE @D1 DATETIMEOFFSET(1) = '2008-05-10 06:59:11.1234567';
DECLARE @D2 DATETIMEOFFSET(2) = '2008-05-10 06:59:11.1234567';
DECLARE @D3 DATETIMEOFFSET(3) = '2008-05-10 06:59:11.1234567';
DECLARE @D4 DATETIMEOFFSET(4) = '2008-05-10 06:59:11.1234567';
DECLARE @D5 DATETIMEOFFSET(5) = '2008-05-10 06:59:11.1234567';
DECLARE @D6 DATETIMEOFFSET(6) = '2008-05-10 06:59:11.1234567';
DECLARE @D7 DATETIMEOFFSET(7) = '2008-05-10 06:59:11.1234567';
PRINT @D;
PRINT @D0;
PRINT @D1;
PRINT @D2;
PRINT @D3;
PRINT @D4;
PRINT @D5;
PRINT @D6;
PRINT @D7;
/*
2008-05-10 06:59:11.1234567 +00:00
2008-05-10 06:59:11 +00:00
2008-05-10 06:59:11.1 +00:00
2008-05-10 06:59:11.12 +00:00
2008-05-10 06:59:11.123 +00:00
2008-05-10 06:59:11.1235 +00:00
2008-05-10 06:59:11.12346 +00:00
2008-05-10 06:59:11.123457 +00:00
2008-05-10 06:59:11.1234567 +00:00
*/
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

覲牛伎螻 矩る 襷企朱 螳伎 濠 螳 覲企. 蠏碁覃 讌 讀蟇一 覦豺 ′ 豺 伎 觜 蟒 伎螻 螳 磯Μ 譯朱 覓伎 る 蟆 蟆企. 襭 5覿 螳 語 蟆一 (企譴)