T-SQL Date by hour difference

[arshesander]

SELECT * FROM Transaction
TransactionDate >= -- code here to compute if the Transaction Date is already 23hours long using UTC Date?

Please help

[FunkyDexter]

Congratulations. You've just set a new standard for terse questions on the forum.

I think you're after this:-

Where DateDiff(hour, TransactionDate, Getdate()) >= 23

If that's not right you're going to have to give us more information about what you're trying to achieve.