http://www.perlmonks.org?node_id=1032758

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. :)