From Now() to Current_timestamp in Postgresql
Posted
by xRobot
on Stack Overflow
See other posts from Stack Overflow
or by xRobot
Published on 2010-06-07T21:55:20Z
Indexed on
2010/06/07
22:02 UTC
Read the original article
Hit count: 140
Filed under:
mysql
|postgresql
In mysql I am able to do this:
SELECT *
FROM table
WHERE auth_user.lastactivity > NOW() - 100
now in postgresql I am using this query:
SELECT *
FROM table
WHERE auth_user.lastactivity > CURRENT_TIMESTAMP - 100
but I get this error:
operator does not exist: timestamp with time zone - integer
How can I resolve ?
© Stack Overflow or respective owner
