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
*/