make_timestamp()

Create timestamp from year, month, day, hour, minute and seconds fields (negative years signify BC)

Signature

make_timestamp ( year int, month int, day int, hour int, min int, sec double precision ) → timestamp

Examples

SELECT make_timestamp(2013, 7, 15, 8, 15, 23.5);

2013-07-15 08:15:23.5

Run against PostgreSQL 18.6 on 2026-09-13. This is the output we got, not the documentation’s.

Want to run this against your own PostgreSQL server from an iPhone, iPad or Mac? These are ours — every connection goes straight from the device to your database, with no account and no server of ours in between.

Postgres & FriendsPostgreSQL and the open-source engines around it

Signature and description adapted from the PostgreSQL manual, used under the PostgreSQL License. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. This page is not affiliated with the PostgreSQL Global Development Group.