Help for this page

Select Code to Download


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