Re: [Dbix-class] Removing rows older than a given number of minutes ...

2010-01-24 Thread Darren Duncan
Octavian Rasnita wrote: Is the following SQL TIMEDIFF( NOW(), ? SECONDS a standard SQL code supported by more databases? Until now I was using SQL codes like now() - interval ? second but I am not sure if the keyword interval is used in other databases than MySQL. Thanks. Octavian

Re: [Dbix-class] Removing rows older than a given number of minutes ...

2010-01-24 Thread Rob Kinyon
On Sun, Jan 24, 2010 at 02:44, Octavian Rasnita octav...@fcc.ro wrote: From: Rob Kinyon rob.kin...@gmail.com $rs-search({   state = $state,   last_modified = [ TIMEDIFF( NOW(), ? SECONDS, $seconds ], })-delete_all; Standard SQL::Abstract stuff, described in both the DBIC cookbook and the