Search code examples
sqlsql-serversql-server-2005

SQL statement to select all rows from previous day

I am looking for a good SQL Statement to select all rows from the previous day from one table. The table holds one datetime column. I am using SQL Server 2005.

Solution

  • get today no time:

    SELECT dateadd(day,datediff(day,0,GETDATE()),0)

    get yesterday no time:

    SELECT dateadd(day,datediff(day,1,GETDATE()),0)

    query for all of rows from only yesterday:

    select 
    * 
    from yourTable
    WHERE YourDate >= dateadd(day,datediff(day,1,GETDATE()),0)
        AND YourDate < dateadd(day,datediff(day,0,GETDATE()),0)