Chapter 19. Date Functions
Almost all business applications require dates in one form or another. Often, you have to store the date an order was entered, generate a quarterly sales report, or compute the number of days a bill has gone unpaid. Dates are deceptively complex: they come in dozens of formats, have sophisticated arithmetic rules (quick, what’s May 21, 1994 from February 29, 2000?), and, in general, give most developers fits. Fortunately, Oracle has provided a set of functions that make the job much easier. This chapter tests your ability to work with dates in PL/SQL, covering topics such as converting a formatted string into a DATE variable or performing date arithmetic.
Beginner
19-1. | What function can you use to move a date forward by six months? |
19-2. | Write a procedure to display the current date and time so the information looks like this: January 17th, 1999 13:05:44 |
19-3. | What function can you use to find the date of the last day in the month for a specified date? |
19-4. | What function can you use to wipe clean the time component of a date variable? |
19-5. | Write a line of code that transforms today’s date to the first date in the current quarter. |
19-6. | Write a line of code that calculates the number of whole months between start_date and end_date. |
19-7. | Write a line of code that moves a date back 18 years. |
19-8. | What is the default time in a variable declared as type DATE? |
19-9. | Write a function that returns the number of days left in the current month. |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.