PostgreSQL to_timestamp function.

Preamble

The PostgreSQL to_timestamp function converts a string into a timestamp.

Syntax of the to_timestamp function in PostgreSQL

to_timestamp( string1, format_mask )

Parameters and function arguments

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

The to_timestamp function can be used in the following PostgreSQL versions

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_timestamp functions to see how to use the to_timestamp function in PostgreSQL.
For example:

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

--Result: 2019-04-23 00:00:00+00

SELECT to_timestamp('2019/04/23 10:13', 'YYYY/MM/DD HH:MI');

--Result: 2019-04-23 10:13:00+00

SELECT to_timestamp('2019/04/23 10:13:18.041.394820', 'YYYY/MM/DD HH:MI:SS.MS.US');

--Result: 2019-04-23 10:13:18.18.43582+00

SELECT to_timestamp('10:13:18.041.394820', 'HH:MI:SS.MS.US');

--Result: 0001-01-01 10:13:18.18.43582+00 BC

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.