Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Question Unanswered: ADD_MONTHS Function

    I need to use the ADD_MONTHS function on a date field with the following format "YYYYMMDD", however, I get erroneous results when using ADD_MONTHS with this format. Does this function only work with the default date format, "DD-MON-YY"????

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    erroneous results, or a syntax error?

    what's the datatype of your date field?

    rudy

  3. #3
    Join Date
    Aug 2002
    Posts
    121
    erroneous results
    date

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    nothing obvious suggests itself

    can you show the query, the original date, and the result?

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    ADD_MONTHS works on any DATE() format fields. You had to be doing something wrong in your query. Either check the syntax of the query one more time, or post it here to tell you what is wrong.


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •