SQL Query - Cisco IPCC DP_CRA_CCDR

[megaco]

Hi,

If I use: select * from ContactCallDetail where startdatetime >= '06/10/2004 12am'

I pull back data, anyone know how to do this so I only pull data for a specific time range say 12am-6-pm etc.

Thanks in advance!

I work for myself - my website is

http://www.call.uk.net

 

[megaco]

After messing around and doing some Internet searching I found the solution:

select * from ContactCallDetail where startdatetime >'2005-06-10 00:00:00.000' AND startdatetime <'2005-06-10 23:59:00.999' AND origCalledNumber = '6950'

This is for anyone that needs this in the future

I work for myself - my website is

http://www.call.uk.net