E.4. DATETIMEOFFSET

DATETIMEOFFSET further enhances the DATETIME2 type by accommodating a time zone offset component. With a storage size of between 8 and 10 bytes, DATETIMEOFFSET types are ideal for multinational database applications.

To further illustrate these data types, let's cast a string in both the old datetime formats (DATETIME and SMALLDATETIME) as well as the four new types covered above: