We can use the following technique in PostgreSQL to return the last day of a given month.
This could be the last day of the current month, or the last day of the month based on a date that we specify.
PostgreSQL
Return Non-Numeric Values from a PostgreSQL Database Column
The following PostgreSQL examples return only those rows that don’t have a numeric value in a given column.
7 Ways to Find Duplicate Rows in PostgreSQL while Ignoring the Primary Key
Here are seven ways to return duplicate rows in PostgreSQL when those rows have a primary key or other unique identifier column.
This means that the duplicate rows share exactly the same values across all columns with the exception of their primary key/unique ID column.
Subtract Months from a Date in PostgreSQL
In PostgreSQL, we can use the - operator to subtract one or more months from a date.
Fix “INSERT has more expressions than target columns” in PostgreSQL
If you encounter an error that reads “INSERT has more expressions than target columns” when trying to insert data in Postgres, it’s because you’re trying to insert data into more columns than the table actually contains.
Subtract Minutes from a Time Value in PostgreSQL
In PostgreSQL, we can use the - operator to subtract one or more minutes from a time value.
By “time” value, this could be an actual time value, a timestamp, or an interval. We can also subtract minutes from a date value or a date and time combination.
Get the Number of Days in a Month in PostgreSQL
Here’s an example of using PostgreSQL to return the number of days in a month, based on a given date.
UPPER() – Convert to Uppercase in PostgreSQL
In PostgreSQL, we can use the upper() function to convert lowercase characters to their uppercase equivalent, according to the rules of the database’s locale.
LOWER() – Convert to Lowercase in PostgreSQL
In PostgreSQL, we can use the lower() function to convert uppercase characters to their lowercase equivalent, according to the rules of the database’s locale.