Get 10 months data from sysdate

[subbaraovangalli]

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

[debasisdas]

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

[susarlasireesha]

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)

[manushka]

Try oracle's interval function