timestamp calculations

Steve Leibel <stevel@bluetuna.com>

From: Steve Leibel <stevel@bluetuna.com>
To: pgsql-general@postgresql.org
Date: 2001-01-25T23:14:58Z
Lists: pgsql-hackers, pgsql-general
Hello,

I'm converting a mysql db to postgres and ran into this line of code:

   $SQL = "select username from users where user_id = ? AND session = ?
           AND ADDDATE(last_login, INTERVAL 30 MINUTE)>CURRENT_TIMESTAMP()

How do I implement adddate to get this kind of funcionality?

Thanks,

Steve Leibel