Microsoft
70-433 · Question #203
You currently store date information in two columns. One column contains the date in local time and one column contains the difference between local time and UTC time. You need to store this data in…
The correct answer is D. datetimeoffset. datetimeoffset defines a date that is combined with a time of a day that has time zone awareness.
Implement Tables and Views
Question
You currently store date information in two columns. One column contains the date in local time and one column contains the difference between local time and UTC time. You need to store this data in a single column. Which data type should you use?
Options
- Atime
- Bdatetime2
- Cdatetime2(5)
- Ddatetimeoffset
How the community answered
(22 responses)- A14% (3)
- B5% (1)
- C5% (1)
- D77% (17)
Explanation
datetimeoffset defines a date that is combined with a time of a day that has time zone awareness.
Topics
#datetimeoffset#UTC offset#datetime data types#time zone storage
Community Discussion
No community discussion yet for this question.