T-SQL Date by hour difference

Code:

---

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

---

Please help

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

I think you're after this:-

Code:

---

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.