PrepAway - Latest Free Exam Questions & Answers

Which function should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
CONVERT

B.
DATEADD

C.
SWITCHOFFSET

D.
TODATETIMEOFFSET


Leave a Reply