Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
Your company has employees in different regions around the world.
You need to create a database table that stores the following employee attendance information:
– Employee ID
– date and time employee checked in to work
– date and time employee checked out of work
Date and time information must be time zone aware and must not store fractional seconds.
Solution: You run the following Transact-SQL statement:
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
Datetimeoffset defines a date that is combined with a time of a day that has time zone awareness and is based
on a 24-hour clock.
Syntaxis: datetimeoffset [ (fractional seconds precision) ]
Forthe use “datetimeoffset(0)”, the Fractional seconds precision is 0, which is required here.
https://msdn.microsoft.com/en-us/library/bb630289.aspx
correct