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?

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?

A.
CONVERT

B.
DATEADD

C.
SWITCHOFFSET

D.
TODATETIMEOFFSET



Leave a Reply 0

Your email address will not be published. Required fields are marked *