Oracle SQL: How to get the First and Last Day of a Month

Simple and Parametric Examples, plus a juicy one.

I was using Oracle SQL and I needed to get the first and last day of a certain month, provided as a parameter. This may help if you have the same problem.

First, I’m going to show you a simple example using today’s date, then I’m going to show you how to…