MS SQL Server - (Current date -1)

Question

I'm looking for something similar to - DATEADD(day,-1,GETDATE())

To use like this - and sale.OrderDateKey >= (current DATE(without time) - 1 day)

e.g. and sale.OrderDateKey >= '2018-07-22'

Answer 1

Use cast datetime(GETDATE()) to date

sale.OrderDateKey >=  DATEADD(day,-1,CAST(GETDATE() as date))