NOW() syntax

Hi all,

I've just started using PostgreSQL in my new job having been using MySQL until now.

I have a timestamp column, with the now() function attached to it.

What I would like to do is now() + 2 hours. So I can make a "timeout" for sessions.

What is the syntax for NOW() + 2 hours?

(date(now() +2) adds 2 days to the time...

Thanks in advance.

mike

now() + interval '2 hours'

Thanks very much for your reply, that did the trick!