Results 1 to 4 of 4

Thread: Get 10 months data from sysdate

  1. #1

    Get 10 months data from sysdate

    suppose we have 2 years data. we want to get a data of 10 weeks data starting from sysdate. i.e when ever we run then query then it gives 10 months data from that sysdate how we can get this


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Get 10 months data from sysdate

    Can you kindly post your query for reference of our experts please.


  3. #3
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Get 10 months data from sysdate

    Quote Originally Posted by subbaraovangalli View Post
    suppose we have 2 years data. we want to get a data of 10 weeks data starting from sysdate. i.e when ever we run then query then it gives 10 months data from that sysdate how we can get this
    USE add_months(sysdate,-10)


  4. #4
    Junior Member
    Join Date
    May 2007
    Answers
    4

    Re: Get 10 months data from sysdate

    Try oracle's interval function


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact