FUNCTIONS / DATA TYPE FORMATTING FUNCTIONS

to_timestamp

Converts string to time stamp according to the given format.

Signatures & examples

to_timestamp ( text, text ) → timestamp with time zone

Converts string to time stamp according to the given format. (See also to_timestamp(double precision) in Table 9.33.)

to_timestamp('05 Dec 2000', 'DD Mon YYYY') → 2000-12-05 00:00:00-05

to_timestamp ( double precision ) → timestamp with time zone

Convert Unix epoch (seconds since 1970-01-01 00:00:00+00) to timestamp with time zone

to_timestamp(1284352323) → 2010-09-13 04:32:03+00

Version history 2

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source