Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Location
    Kuala Lumpur
    Posts
    38

    Unanswered: date difference in oracle

    Hi Guys,
    I need your help to solved this issue.
    I'm using oracle 9i, problem now I want to select data that old 6 months from sysdate. How Can i do that? I have one field for date, his field can be use to diff the date from sysdate. I know how to do in sql server but not in oracle. Pls help me on this

    Thank in advance

    Regards,
    Shaffiq

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    WHERE date_column <= ADD_MONTHS(TRUNC(sysdate), -6)

  3. #3
    Join Date
    Oct 2004
    Location
    Kuala Lumpur
    Posts
    38
    Thanks little foot,
    Its help me a lot

    Thx VM

    Regards
    Shaffiq

Posting Permissions

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