• Talking about date and time data types it's also interesting to mention new function SWITCHOFFSET which returns a datetimeoffset that is changed from the stored offset to a new time zone offset (see BOL).

    Datitime2 is typical Oracle naming convention for new added types and I don't like it too 🙂