With a storage footprint of between 6 and 8 bytes, DATETIME2 combines the advantages of the DATE and TIME types, enhancing DATETIME by allowing dates from 0001 and times accurate to 100 nanoseconds.
