Using Sysdate to determine start and end of previous month and year in Oracle SQL

Wow, that title is a mouthful.
Basically i figured out how to use SYSDATE and some other temporal methods to automatically determine the first and last day of the previous month, or previous year.
I needed this to hand off  a canned query that can be used by many users without the need to constantly update the [...]

Please visit EdwardAWebb.com to view the rest of this article without ads.