Oracle Datetime - Exercises with Solution

Last update on March 08 2024 13:45:27 (UTC/GMT +8 hours)

Oracle Datetime [8 exercises with solution]

1. Write a Oracle SQL statement to get the first date of the current month.

2. Write a Oracle SQL statement to get the last date of the current month.

3. Write a Oracle SQL statement to get the current date in the specified session time zone.

4. Write a Oracle SQL statement to determine how many days are left in the current month.

5. Write a Oracle SQL statement to get the first and last day of the current year.

6. Write a Oracle SQL statement to get the number of days in current month.

7. Write a Oracle SQL statement to get number of days between two given dates.

8. Write a Oracle SQL statement to get the start date and end date of each month in current year from current month.

More to Come !