↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / Date/Time Functions And Operators

timestamp

Read the PG 7.2 manual

date to timestamp

Reading PG 7.2·documented in 2 of 27 versions, 7.1 to 7.2

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Historical documentation for a PostgreSQL version that is no longer supported.

Signatures & examples

timestamp ( date ) → timestamp
date to timestamp
timestamp(date '2000-12-25') → 2000-12-25 00:00:00
timestamp ( date, time ) → timestamp
date and time to timestamp
timestamp(date '1998-02-24',time '23:07') → 1998-02-24 23:07:00
Version history 2
  1. 7.2 → 7.3 removed
  2. 7.1 → 7.2 changed

Definition snapshot: b7bd9cda · English manual source