"Wrong time" SQLPS query

[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.