kingmx has asked for the wisdom of the Perl Monks concerning the following question:
Has anyone know how to search database by date range?
I'm using Perl Catalyst framework and I want to produce a query like this.
SELECT * FROM table WHERE date BETWEEN 2013-05-03 AND 2013-05-04;
Here's my code and I'm stuck on thinking how to write the "where" clause.
my $rs = [$c->model('DB::table')->search( { 'me.date' => ???? } ,{} )];
Thanks. :)
Back to
Seekers of Perl Wisdom