What should you do?

You develop a database for a travel application. You need to design tables and other database objects.

You create a view that displays the dates and times of the airline schedules on a report.

You need to display dates and times in several international formats.

What should you do?
A . Use the CAST function.
B . Use the DATE data type.
C . Use the FORMAT function.
D . Use an appropriate collation.
E . Use a user-defined table type.
F . Use the VARBINARY data type.
G . Use the DATETIME data type.
H . Use the DATETIME2 data type.
. Use the DATETIMEOFFSET data type.
. Use the TODATETIMEOFFSET function.

View Answer

Answer: C

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/hh213505.aspx