Return the Start of the Month in SQLite

SQLite gives us the ability to return the date of the beginning of the month, based on a given date.

This means we can return the date of the first day of the current month, or the first day of the month based on a date that we specify.

This allows us to perform further calculations on the resulting date, like adding a given number of days to it.

Continue reading

PostgreSQL DATEADD() Equivalent

Updated 20 April 2024 to include the date_add() function.

SQL Server has its DATEADD() function that adds an interval to a date value. MySQL’s DATE_ADD() and ADDDATE() for does the same thing, as does MariaDB’s DATE_ADD() and ADDDATE(). SQLite has a DATE() function that also provides the option of adding an interval to a given date.

Prior to version 16, PostgreSQL didn’t have a DATEADD() or equivalent function. But with PostgreSQL 16 came with the introduction of the date_add() function, which allows us to add an interval to a timestamp with time zone.

We can also add and subtract values from dates with date/time operators such as + and -.

Continue reading