Home Forums SQL Server 2008 SQL Server 2008 - General Getting t-1 RE: Getting t-1

  • November 25, 2015 at 3:13 am

    #1842261

    Try this code

    select convert(datetime,convert(date,getdate()-1)),DATEADD(millisecond,-3,convert(datetime,DATEADD(day,1,convert(date,getdate()-1))))

    Igor Micev,My blog: www.igormicev.com