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.