Guys,
I need to know the query to convert utc timings into gmt +5 in swql for lastboot column in nodes table. In sql management studio, it's very easy however i am unable to do the same in swql.
Any help will be highly appreciated.
Regards,
Mike.
-
Hi,
Something like that?
SELECT NodeID, Caption, ChangeTimeZone(LastBoot,'+05:00') as LastBoot_5
FROM Orion.Nodes
There are some helpful examples here:
Orion SWQL, Thwack! Now I got it
Antonis Athanasiou
Prosperon - UK SolarWinds Partners
Installation | Consultancy | Training | Licenses
