Getting incorrect DateTime format for Orion.AlertActive.TriggeredDateTime field

Question

Hello folks,

I am getting letter 'T' printed in between Date and Time when I am querying to the Table AlertActive and Column TriggeredDateTime. Also Time contains milliseconds in it.

Any idea how to get rid of this letter T and milliseconds?

My Query is

SELECT aa.TriggeredDateTime

FROM Orion.AlertActive AS aa

and Output I'm getting is as below:

2023-06-07T23:55:15.36

2023-06-07T21:50:53.28

2023-06-07T21:48:40.34

bucweat · Accepted Answer

The time with the "T" is ISO-8601 format

https://www.w3.org/TR/NOTE-datetime

How arre you running the query? Which version of SAM do you have? I have 2023.2.1 when I run that query in SWQLStudio I get times that loook like 2023-06-19 16:30:34.76. Check out https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions there are date and time functions you can use to format time to your liking.