Oracle Datetime - Exercises with Solution

Oracle Datetime [8 exercises with solution]

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

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

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

Click me to see the solution

More to Come !