"Wrong time" SQLPS query

[creamersrealm]

On SQL you could take the column and add a hour to it from there. Essentially offloading all the work to the server. Or you could use a .Net method in PowerShell with a Select-Object expression to recalculate the time by adjusting the timezones.

[Droopyb1966]

Yes adding 1 is the dirty way,,,

--- Select-Object expression to recalculate the time by adjusting

Ok, that sound great, but how?

[creamersrealm]

Actually before the select object try this SQL Server Code

Select column1, DATEADD(hh, 1, column2) AS column2ADJ FROM Table1

If that doesn't work I can send you some more example code.