DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
mm-d-yyyy
|
|
ddd mmm-d-yyyy
|
|
mm-d-yyy
|
|
mm-yyyy
|
Detailed explanation-1: -Explanation: datestamp is not a valid Date and Time data type. Timestamp exists but datestamp does not exist in SQL.
Detailed explanation-2: -MM/DD/YY. Two-digit month, separator, two-digit day, separator, last two digits of year (example: 12/15/99) YYYY/MM/DD. Four-digit year, separator, two-digit month, separator, two-digit day (example: 1999/12/15)
Detailed explanation-3: -The United States is one of the few countries that use “mm-dd-yyyy” as their date format–which is very very unique! The day is written first and the year last in most countries (dd-mm-yyyy) and some nations, such as Iran, Korea, and China, write the year first and the day last (yyyy-mm-dd).
Detailed explanation-4: -When using %m, single digit months are displayed with a leading zero. For example, %f %e %Y will display the date 2 5 2018 with a single digit for the month. The format specifier %m %d %Y will display the date 02 05 2018 with a leading zero for the month.