PostgreSQL to_date function.

Preamble

The to_date function in PostgreSQL converts a string into a date.

Syntax of the to_date function in PostgreSQL

to_date( string1, format_mask )

Parameters and function arguments

• string1 – String that will be converted to a date.
• format_mask – The format that will be used to convert string1 to date. This can be one of the following and can be used in many combinations.

The to_date function can be used in future versions of PostgreSQL

PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.

Let’s look at some examples of to_date functions to see how to_date can be used in PostgreSQL.

SELECT to_date('2019/04/23', 'YYYY/MM/DD');

-- Result: 2019-04-23

SELECT to_date('042319', 'MMDDYY');

-- Result: 2019-04-23

SELECT to_date('February 08, 2019', 'Month DD, YYYYY');

-- Result: 2019-02-08

Date functions in PostgreSQL , Time functions in PostgreSQL

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.