Home Forums SQL Server 2005 SQL Server 2005 General Discussion What is this saying ? RE: What is this saying ?

  • April 29, 2013 at 12:43 pm

    #1610951

    steve4134 (4/29/2013)

    I believe this is saying Last day of previous month and first day of current month ? Can someone please confirm ?

    Steve

    DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101))

    and

    DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),101))

    run this in SSMS

    select DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101))

    select DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),101))

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day