MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the CURDATE() function in MySQL?

How does the NOW() function differ from the CURDATE() function in MySQL?

What is the use of the DATE() function in MySQL?

Explain how the DATEDIFF() function is used in MySQL.

What is the purpose of the DATE_ADD() function in MySQL?

How does the EXTRACT() function work in MySQL?

Describe how the STR_TO_DATE() function can be used in MySQL.

What is the significance of the LAST_DAY() function in MySQL?

How can the TIMESTAMPDIFF() function be utilized in MySQL?

During a database certification exam, you are asked to explain the purpose and usage of the DATE_FORMAT() function. What would be your response?