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
Printable View
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
Can you kindly post your query for reference of our experts please.
[QUOTE=subbaraovangalli;20986]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[/QUOTE]
USE add_months(sysdate,-10)
Try oracle's interval function