2 Replies Latest reply on Mar 30, 2016 5:50 PM by mwb

    SWQL Conversion for Linux Epoch Time


      Out of my depth on this one - typically I deal with Windows boxes.

      For those who are not familiar, some items track time passage with Linux Epoch time, which counts the number of seconds since 1/1/1970.  Great for computers, not so good for people as "1452714901" doesn't mean much to a human.


      In SQL, I was able to convert with:


      DateAdd(s, (select CAST(<MYEPOCHDATE> as INT)), '19700101') as <MYNEWDATE>


      I'm banging my head against the wall trying to convert in SWQL for a custom query resource for a dashboard view.


      Any assistance would be appreciated.