cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
784
Views
20
Helpful
3
Replies

Escape Character in Anonymous Block Report Definition

peterputt
Beginner
Beginner

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

3 Replies 3

bill.king1
VIP Advocate VIP Advocate
VIP Advocate