You manage a database named Exams accessed via a website. The website is regularly accessed by users in
different countries. You are redesigning a table named History that records when users have purchased and
taken online exams. You need one of the columns in the History table to record what time of day that auser
has taken an exam. Additionally, you need this column to have time zone awareness. What data type should
you use?
A.
datetimeoffset
B.
datetime
C.
Use two different columns with one column of datetime, and the second column indicating the UTC offset
D.
datetime2
Explanation:
The datetimeoffset data type combines a date with atime of day that has time zone awareness. The timeis
based on a 24-hour clock but also
includes a UTC offset. For the datetimeoffset data type, both the UTC and local datetime values will be
validated during update, insert,
convert, arithmetic, or assign operations. The recognition of any invalid UTC or local datetime value will result
in an invalid value error. For
example, the 9999-12-31 10:10:00 datetime value is valid in UTC, but it overflows in local time when the time
zone offset is +13:50.
The datetimeoffset data type combines a date with atime of day that has time zone awareness. The timeis
based on a 24-hour clock but also
includes a UTC offset. For the datetimeoffset data type, both the UTC and local datetime values will be
validated during update, insert,
convert, arithmetic, or assign operations. The recognition of any invalid UTC or local datetime value will result
in an invalid value error. For
example, the 9999-12-31 10:10:00 datetime value is valid in UTC, but it overflows in local time when the time
0
0
Every after in a whilst we select blogs that we study. Listed below are the newest web-sites that we pick.
0
0