cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

system variables like Date and Time into CRA

CARLO CALABRESE
Beginner
Beginner

I'm doing a dip into a SQL database and need to check a records date and time to the current date and time on the ipcc. I cannot find were there is a list of system variables that I can pull from.

Is there a list of the system variables that can be pulled?

2 REPLIES 2

russellhampton
Beginner
Beginner

Hi Mate

had a simular problem, and it is a reall pain to do the date work in the CRA. so I sugest you just do it in the SQL

eg

select getdate() DT, getdate() - RouterLongestCallQ DD from Call_Type_Real_Time

will give the current time in DT, but even better the DD has the time that the longest call has been waiting.

Hope that helps

Regards Russell

yogeswar
Enthusiast
Enthusiast
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: