How to search database by date range

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;
[download]

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' => ???? }
       ,{}
    )];
[download]

Thanks. :)

Comment on How to search database by date range Select or Download Code

Replies are listed 'Best First'.
Re: How to search database by date range by tobyink (Canon) on May 09, 2013 at 15:53 UTC
FWIW, just because you're using Catalyst, there's no law that compels you to use DBIx::Class too. `package Cow { use Moo; has name => (is => 'lazy', default => sub { 'Mooington' }) } say Cow->new->name`	[reply]
Re^2: How to search database by date range by kingmx (Initiate) on May 11, 2013 at 06:23 UTC
Wow, thank you guys for the replies. I solved the problem with this code. `my $rs = [$c->model('DB::table')->search( { 'me.date' => { "<=" => "2013-05-04", ">=" => "2013-05-03" } } ,{} )];` [download] To ww: sorry if I didn't put the actual codes. The reason is, I just want to limit my question to what I really needed. To thundergnat: Thanks for the link! I find it very informative. I will also try your suggestion.	[reply] [d/l]
Re: How to search database by date range by ww (Archbishop) on May 09, 2013 at 11:15 UTC
It might also be helpful to tell us WHICH database. If you didn't program your executable by toggling in binary, it wasn't really programming!	[reply]
Re: How to search database by date range by thundergnat (Deacon) on May 09, 2013 at 15:42 UTC
It probably will be something like: `my $rs = [$c->model('DB::table')->search( { 'me.date' => { between => ['2013-05-03', '2013-05-04'] } } ,{} )];` [download] Check the SQL::Abstract docs for the gritty details.	[reply] [d/l]
Re: How to search database by date range by Anonymous Monk on May 09, 2013 at 11:02 UTC
I'm using Perl Catalyst framework and I want to produce a query like this. Catalyst comes with many classes/plugins.... so which one are you using? What is your model class?	[reply]