Adding interval to current timestamp in PostgreSQL

Question

I want to add an interval of 23 hours to the current date and time in PostgreSQL. The query should look something like the following:

SELECT timestamp LOCALTIMESTAMP(0) + interval '23 hours';

For some reason, the preceding statement returns an error. What could be wrong here and why is it not working?

A date is very different in nature from a timestamp, btw. — Erwin Brandstetter
– Erwin Brandstetter, Commented Apr 25, 2013 at 1:46

Anuj Patel · Accepted Answer · 2013-04-24 22:15:11Z

3

Remove TimeStamp keyword

SELECT LOCALTIMESTAMP(0) + interval '23 hours'

or use

SELECT now() + interval '23 hours'

user330315

answered Apr 24, 2013 at 22:03

Anuj Patel

17.9k3 gold badges32 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1