In PostgreSQL you can use the EXTRACT() function to get the month from a date.
You can also use the DATE_PART() function to do the same thing.
Category: Object-Relational
Convert Month Number to Month Name in PostgreSQL
You can use the following code examples in PostgreSQL if you have a month number but you want the month name instead.
Convert Month Name to Month Number in PostgreSQL
In PostgreSQL, if you already have a month name, but you want to convert that name to the month number, you can do this with the EXTRACT() function.
Get the Month Name from a Date in PostgreSQL
If you’re familiar with PostgreSQL, you might know that you can use the EXTRACT() and the DATE_PART() functions to extract the month from a date. But those functions only allow you to extract the month number.
What if you need the month name?
You can get the month name from a date by using the TO_CHAR() function. This function returns a string based on the timestamp and the template pattern you provide as arguments.
How to Check your PostgreSQL Version
In this article I present several ways to check your PostgreSQL version.
How to Return a List of Available Collations in PostgreSQL
In PostgreSQL, we can use the pg_collation catalog to get a list of the available collations. Another way to do it is to use the \dOS command.
Using the first method, we can run the following statement to return a list of available collations in PostgreSQL:
SELECT * FROM pg_collation;
These collations are mappings from an SQL name to operating system locale categories.
SQL DROP TABLE Syntax – Listed by DBMS
This article lists the SQL DROP TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
What is Oracle Database?
Oracle Database is an object-relational database management system (ORDBMS) produced by Oracle Corporation. It is one of the world’s most popular database management systems (DBMSs).
Oracle Database is often shortened to “Oracle” and sometimes “Oracle DB” or “Oracle RDBMS” (although it’s not the only product from Oracle Corporation).
What is PostgreSQL?
PostgreSQL is an object-relational database management system (ORDBMS). It is an open source system that is known for its close alignment with the SQL standard.
PostgreSQL is one of the world’s most popular database management systems (DBMS), and it is consistently in the top 5 on the DB-Engines ranking list.
SQL TRUNCATE Syntax – Listed by DBMS
This article lists the SQL TRUNCATE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.