Review Questions:
1. What is the use of add_months function in SQL?
2. What does the months_between function do?
3. Which of the following is the output of the last_day function?
a. Gives the last day of the week for the specified date.
b. Gives the last day of the month for the specified date.
c. Gives the last date of the month for the specified date.
d. None of the above.
4. Explain next_day function in SQL.
5. What is the format in which Oracle SQL generally displays a date?
6. While inserting a date in a table, do you need to use single quotes?
7. Which data type is used to store dates in Oracle SQL?
On this page of the site you can watch the video online SQL -Date Functions with a duration of hours minute second in good quality, which was uploaded by the user Coding Christi -Python, Java, SQL 15 December 2020, share the link with friends and acquaintances, this video has already been watched 265 times on youtube and it was liked by 4 viewers. Enjoy your viewing!