SQL Server select where datetimeoffset older than 1 hour
WHERE mydatetime < DATEADD(hour, -1, SYSDATETIMEOFFSET())
For more see: DATEADD (Transact-SQL)
select * from table where mydatetime < dateadd(hh, -1, getdate())
WHERE mydatetime < DATEADD(hour, -1, SYSDATETIMEOFFSET())
For more see: DATEADD (Transact-SQL)
select * from table where mydatetime < dateadd(hh, -1, getdate())