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.
Something like that?
SELECT NodeID, Caption, ChangeTimeZone(LastBoot,'+05:00') as LastBoot_5 FROM Orion.Nodes
There are some helpful examples here:
Installation | Consultancy | Training | Licenses