invalid input syntax for type timestamp

[clay1]

This function is throwing the following error:

 

invalid input syntax for type timestamp "1301297896"

 

 function removeInactiveUsers(){
      if(!TRACK_VISITORS) return;
      $timeout = time()-USER_TIMEOUT*60;
      
$result = pg_query_params($this->connection, "delete from active_users where timestamp < $1", array($timeout));
      $this->calcNumActiveUsers();
   }

 

I know the problem is with $timeout using a php timestamp vs postgresql timestamp but I'm not sure how to fix that

[clay1]

$result = pg_query_params($this->connection, "delete from active_users where timestamp < to_timestamp($1)::TIMESTAMP", array($timeout));

 

Seems to be working