Geek Culture
Published in

Geek Culture

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…




A new tech publication by Start it up (

Recommended from Medium

| Engineering News-Record

Operation not possible due to RF-kill

Extra-Strength Methods

What to Expect When You’re Expecting a Hybrid App

Braze Python Campaigns

How We Use Exploratory Testing Sessions to Prevent Bugs

Run the ganache-cli inside the Docker Container

Some coding stuff I’m glad I know

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Daniele Quero, PhD

Daniele Quero, PhD

A professional developer with passion for game developing and skill-growing. A former Nuclear Physics Researcher who changed his life to pursue his dreams

More from Medium

SELECT statement for SQL

SELECT statement for SQL

PrepareSQLAggregationTop Earners

Working with dates on SQL — Practice Example 1 (Self Join)

Limit Rows with the WHERE clause — MySQL Beginner Series