Bonjour,
dans ma table cdr sous mysql, le champ calldate est un timestamp, pas un datetime. Tu as eu ou ta définition de table ?
Voici la mienne :
CREATE TABLE IF NOT EXISTS `cdr` (
`id` int(10) unsigned NOT NULL auto_increment,
`calldate` timestamp NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(39) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`answer` timestamp NOT NULL default '0000-00-00 00:00:00',
`end` timestamp NOT NULL default '0000-00-00 00:00:00',
`duration` int(10) unsigned NOT NULL default '0',
`billsec` int(10) unsigned NOT NULL default '0',
`disposition` varchar(9) NOT NULL default '',
`amaflags` tinyint(2) unsigned NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`uniqueid` varchar(32) NOT NULL default '',
`userfield` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cdr__idx__calldate` (`calldate`),
KEY `cdr__idx__clid` (`clid`),
KEY `cdr__idx__src` (`src`),
KEY `cdr__idx__dst` (`dst`),
KEY `cdr__idx__channel` (`channel`),
KEY `cdr__idx__dstchannel` (`dstchannel`),
KEY `cdr__idx__duration` (`duration`),
KEY `cdr__idx__disposition` (`disposition`),
KEY `cdr__idx__amaflags` (`amaflags`),
KEY `cdr__idx__accountcode` (`accountcode`),
KEY `cdr__idx__userfield` (`userfield`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8784 ;