can we convert date to UNIX_TIMESTAMP in Solarwinds SDK ?

can we convert the date to UNIX_TIMESTAMP in Solarwinds SDK?

Find more posts tagged with

You could use SECONDDIFF and January 1st, 1970 to get that value like this:

SELECT TOP 1 SECONDDIFF('01-01-1970 00:00:00', GETUTCDATE()) AS UnixTimeStamp FROM Orion.Nodes

You could use SECONDDIFF and January 1st, 1970 to get that value like this:

SELECT TOP 1 SECONDDIFF('01-01-1970 00:00:00', GETUTCDATE()) AS UnixTimeStamp FROM Orion.Nodes

Thanks for ur reply