Showing results for 
Search instead for 
Did you mean: 

Add value to datetime string with PQL

IR Partner

Add value to datetime string with PQL

Hello Community,


does anyone know how to add values with PQL to a datetime string (format YYYY-mm-dd HH:MMSmiley FrustratedS.000Z) ?




Re: Add value to datetime string with PQL

Yes you can do that, here is example of adding 10 hours to the date timestamp:


irpqlcli.exe -r "select * from ntcpu database 'ntcpu' period @fromtime to @totime" -b fromtime=2019-08-26T10:00:00.000000+10:00 -b totime=2019-08-26T10:37:00.000000+10:00


Online Help has more details such as this article. 

online help > Operations > Miscellaneous Operations > Prognosis Query Language (PQL)



Webinar: The Journey to Microsoft Teams - Readiness Phase (part 2)

Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.

Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.

Join webinar