Microsoft
70-433 · Question #134
You are a database developer located in Seattle. You have a client in Melbourne, which is in a different time zone from Seattle. You have been using the datetimeoffset data type and storing data by…
The correct answer is C. SWITCHOFFSET. See the full explanation below for the reasoning.
Question
You are a database developer located in Seattle. You have a client in Melbourne, which is in a different time zone from Seattle. You have been using the datetimeoffset data type and storing data by using the Seattle offset. You need to display the dates in the Melbourne offset. Which function should you use?
Options
- ACONVERT
- BDATEADD
- CSWITCHOFFSET
- DTODATETIMEOFFSET
How the community answered
(26 responses)- A4% (1)
- B12% (3)
- C77% (20)
- D8% (2)
Community Discussion
No community discussion yet for this question.