Date add function in As400 db2

  • Can any one help me convert the SQl statement into a db2 statement

    CAST(CONVERT(varchar, DATEADD(d, - (DAY(DATEADD(m, 1, GETDATE())) - 1), DATEADD(m, - 1, GETDATE())), 112) AS INT)

    I av no knowledge abt the db2 database, kindly extend your help, thank you so much

    Aaditya

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply