Quiz for Date Functions

Q1: Which SQL function returns the current date and time?

A. SYSDATE() B. NOW() C. GETDATE() D. CURDATE()

Q2: What does the CURDATE() function return?

A. Current time B. Current date C. Current year D. Current timestamp

Q3: Which function extracts the year from a date?

A. YEAR() B. MONTH() C. DAY() D. EXTRACT()

Q4: What does the DATEDIFF() function do?

A. Adds two dates B. Subtracts two dates C. Compares two dates D. Returns current date

Q5: Which function adds days to a date?

A. DATE_ADD() B. DATE_SUB() C. ADDDATE() D. DATEDIFF()

Q6: Which function subtracts days from a date?

A. DATE_ADD() B. DATE_SUB() C. DATEDIFF() D. SUBDATE()

Q7: Which function returns the name of the weekday for a date?

A. DAY() B. DAYNAME() C. WEEKDAY() D. DATE_FORMAT()

Q8: What is the result of MONTH("2024-07-19")?

A. 7 B. 6 C. 8 D. 19

Q9: Which function returns the day of the month from a date?

A. DAY() B. WEEKDAY() C. DAYOFWEEK() D. DAYNAME()

Q10: What does the WEEKDAY() function return?

A. Day name B. Week number C. Day index (0=Monday) D. Month name

Q11: What is the return type of NOW()?

A. DATE B. TIME C. DATETIME D. VARCHAR

Q12: What does DATE_FORMAT() do?

A. Formats date as text B. Changes timezone C. Compares dates D. Calculates date difference

Q13: Which function returns the day of the week (1=Sunday)?

A. DAYOFWEEK() B. WEEKDAY() C. DAYNAME() D. DAY()

Q14: What does STR_TO_DATE() do?

A. Converts string to date B. Formats date to string C. Calculates days between dates D. Extracts year

Q15: What is the output of YEAR("2023-11-05")?

A. 2023 B. 11 C. 05 D. 0

Q16: Which function returns the current date without time?

A. NOW() B. SYSDATE() C. CURDATE() D. CURRENT_TIMESTAMP()

Q17: Which SQL function can calculate age?

A. DATEDIFF() B. DATE_SUB() C. TIMESTAMPDIFF() D. AGE()

Q18: Which function extracts only time from datetime?

A. CURTIME() B. NOW() C. CURRENT_DATE() D. DAY()

Q19: What is the return value of DAYNAME("2024-07-19")?

A. Friday B. Saturday C. Thursday D. Sunday

Q20: Which function adds interval to date in MySQL?

A. ADDDATE() B. SUBDATE() C. DATEDIFF() D. CURDATE()