Home Forums SQL Server 2005 SQL Server 2005 Compact Edition query for getting yesterday date entry RE: query for getting yesterday date entry

  • July 14, 2008 at 5:23 am

    #842306

    I think this is what you need however without further info I cannot be sure:

    SELECT

    *

    FROM

    sometable

    WHERE

    somedatecolumn >= dateadd(dd,datediff(dd,0,getdate()),-1)

    AND

    somedatecolumn < dateadd(dd,datediff(dd,0,getdate()),0)

    Nigel
    How to post questions