clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1044276 fiddles created (9431 in the last week).

DECLARE @now DATETIME2 = GETDATE() -- Default is precision 7 SELECT CAST(@now AS DATETIME2(0)) AS [DateTime2(0)] , CAST(@now AS DATETIME2(1)) AS [DateTime2(1)] , CAST(@now AS DATETIME2(2)) AS [DateTime2(2)] , CAST(@now AS DATETIME2(3)) AS [DateTime2(3)] , CAST(@now AS DATETIME2(4)) AS [DateTime2(4)] , CAST(@now AS DATETIME2(5)) AS [DateTime2(5)] , CAST(@now AS DATETIME2(6)) AS [DateTime2(6)] , CAST(@now AS DATETIME2(7)) AS [DateTime2(7)/Default]
DateTime2(0) DateTime2(1) DateTime2(2) DateTime2(3) DateTime2(4) DateTime2(5) DateTime2(6) DateTime2(7)/Default
2020-01-14 22:38:07.0000000 2020-01-14 22:38:06.8000000 2020-01-14 22:38:06.7600000 2020-01-14 22:38:06.7570000 2020-01-14 22:38:06.7567000 2020-01-14 22:38:06.7566700 2020-01-14 22:38:06.7566670 2020-01-14 22:38:06.7566667
 hidden batch(es)