Microsoft
70-457 · Question #22
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…
The correct answer is C. Use the FORMAT function. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the CAST function.
- BUse the DATE data type.
- CUse the FORMAT function.
- DUse an appropriate collation.
- EUse a user-defined table type.
- FUse the VARBINARY data type.
- GUse the DATETIME data type.
- HUse the DATETIME2 data type.
- JUse the TODATETIMEOFFSET function.
How the community answered
(44 responses)- B5% (2)
- C77% (34)
- D2% (1)
- E9% (4)
- F7% (3)
Community Discussion
No community discussion yet for this question.