[Dbix-class] mysql date_sub function in DBIx catalyst call

daniel at caret.cam.ac.uk daniel at caret.cam.ac.uk
Thu Jan 18 17:20:56 GMT 2007


Argh, sorry... I think I finally cracked it:

my $last_hour = "> DATE_SUB( NOW(), INTERVAL 1 HOUR )";
my $current_session = $c->model('SmsDB::Session')->search({ -and => [
                                              { id => 'foo' },
                                              { created => \$last_hour }
]});

Apologies for bothering you all!

Best wishes,

Daniel

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.




More information about the Dbix-class mailing list