[dancer-users] howto query between date ?

12 Feb 2014

      hello

i write this in my sub

my $count_DossiersClos = database('asav')->quick_count(
            'DossierClos',
            {DateCloture =>{ 'lt' => "2013-12-01 00:00:01"},DateCloture =>
{ 'gt' => "2013-11-01 00:00:01"}});
                return $count_DossiersClos;

but the query just use the last  Date cloture and in mysql.log i read

140212 17:05:21    18 Connect   admin@localhost on asav
                   18 Query     set autocommit=1
                   18 Query     SELECT COUNT(*) FROM `DossierClos` WHERE
`DateCloture` > '2013-11-01 00:00:01'

ingenuous i hope :
SELECT COUNT(*) FROM `DossierClos` WHERE `DateCloture` > '2013-11-01
00:00:01' and `DateCloture` < '2013-12-01 00:00:01'

does it better to write the query ?

regards
T.

[dancer-users] howto query between date ?

Tonton