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 1:18 am

    #842221

    try this query,it works for me

    select * from testdate where datepart(dd,date1)=datepart(dd,getdate())-1

    so ,i hope this work for you