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

    SWQL Conversion for Linux Epoch Time

    mwb

      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.