1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle to sql

Discussion in 'General' started by Pasi, Jan 17, 2018.

  1. Pasi

    Pasi Newly Initiated

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    USA
    Hi ,

    I have below conversion from Oracle to SQL can you please chk and let me know if i did the conversion correct?
    Thanks! It does not look correct, any help appreciated!
    The syntax for SQL is DATEADD(month,1,"my date") but not sure how to construct this in SQL? I dont think my conversion is correct.

    --ADD_MONTHS(A.ENTRY_DT, ST.INCR_TIME * 6 ) , (ADD_MONTHS(A.ENTRY_DT, ST.INCR_TIME * 6 ) ) - SYSDATE , --- Oracle

    SQL

    DATEADD(month,A.ENTRY_DT, ST.INCR_TIME *6), (DATEADD(month,A.ENTRY_DT, ST.INCR_TIME * 6 ) ) - GETDATE() ,
     
    Last edited: Jan 17, 2018