By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DateTime | SmallDateTime | Date | DateTime2(0) | DateTime2(1) | DateTime2(2) | DateTime2(3) | DateTime2(4) | DateTime2(5) | DateTime2(6) | DateTime2(7)/Default |
---|---|---|---|---|---|---|---|---|---|---|
2020-01-16 10:05:15.177 | 2020-01-16 10:05 | 2020-01-16 | 2020-01-16 10:05:15.0000000 | 2020-01-16 10:05:15.2000000 | 2020-01-16 10:05:15.1800000 | 2020-01-16 10:05:15.1770000 | 2020-01-16 10:05:15.1767000 | 2020-01-16 10:05:15.1766700 | 2020-01-16 10:05:15.1766670 | 2020-01-16 10:05:15.1766667 |