Hi,

I have a SQL query that gives me DATETIME column in a single row as a result. Result looks like:

Jun 15 2022 11:04AM or
11:04 depends on how I convert it.

What should be the correct way to represent SQLL DATETIME to Date, hours, minutes and not: 3,864,279,759.08 which doesn't make sense?

Should I convert it to some PRTG format that then could be represented correctly by PRTG?

I have looked into documentation but for: date format, convert date, ... and time I have found nothing.

Thank you,

Article Comments

Hello,
Within the sensor settings you can enable the option "Process data table" in order create additional channels. However please note that only numerical values can be displayed. "Jun 15 2022 11:04AM" seems to be a string. Maybe this example might however be of interest for you to display strings within the message field of the sensor instead as workaround.


Jun, 2022 - Permalink