What are some examples of time functions in SQL?

What are some examples of time functions in SQL?

SQL provides several time functions like NOW(), CURDATE(), and DATE_ADD(). Would you like to see examples of how to use them?

Yes, please show me how to use NOW() and CURDATE().

Sure! The NOW() function returns the current date and time, while CURDATE() returns the current date. For example:

1. SELECT NOW();
2. SELECT CURDATE();

Would you like to know more about other time functions?

What about DATE_ADD()? How does that work?

DATE_ADD() adds a specified time interval to a date. For example:

SELECT DATE_ADD('2023-01-01', INTERVAL 10 DAY);
This will return '2023-01-11'. Would you like more examples?