Hi
I'm trying to create a report to get the calls per hour for certain application... My query is running fine, but if I put it into an Anonymous Block, CUIC interprets "::DATETIME" as a parameter:
select startdatetime::DATETIME HOUR TO HOUR AS CallHour, count(*) from contactcalldetail where
startdatetime between :START and :END and
applicationname = :APP
group by CallHour
order by CallHour
How can I escape the ":"?
Thanks in advance
Peter