- or download this
SELECT * FROM session WHERE
EXTRACT(EPOCH FROM lastop) < EXTRACT(EPOCH FROM CURRENT_TIMESTAMP) - $
+timeout
- or download this
SELECT * FROM session WHERE
UNIX_TIMESTAMP(lastop) < UNIX_TIMESTAMP(CURRENT_TIMESTAMP) - $timeout
- or download this
SELECT * FROM session WHERE
lastop < now() - interval $timeout second
- or download this
SELECT * FROM session WHERE
lastop < now() - interval '$timeout second'