Add value to datetime string with PQL

Highlighted
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) ?

 

BR
Bernd

1 REPLY 1
Sage

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)

 

HTH

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar