SELECT
*
FROM
hdcdrinfo
WHERE callstate = 1
AND calledphonenumber = 9008
AND logtime BETWEEN TO_DATE (
'2015-04-23 14:00:00',
'yyyy-mm-dd hh24:mi:ss'
)
AND TO_DATE (
'2015-04-23 14:06:38',
'yyyy-mm-dd hh24:mi:ss'
) ;
SELECT
*
FROM
web800callbackitemlist
WHERE STATUS = 2
AND callingnumber = 9008
AND createtime BETWEEN TO_DATE (
'2015-04-23 14:00:00',
'yyyy-mm-dd hh24:mi:ss'
)
AND TO_DATE (
'2015-04-23 14:06:38',
'yyyy-mm-dd hh24:mi:ss'
) ;