OK, my previous query is giving the following week's first day, so we can modify it as:
SELECT trunc(trunc(SYSDATE, 'YEAR') + (46 * 7) - 7, 'WW') FROM dual; You may wrap the query into a function as always for the sake of simplification. Best regards, Mehmet 2011/11/15 Mehmet Kirazoglu <[email protected]> > Hello, > > SELECT trunc(trunc(SYSDATE, 'YEAR') + (46 * 7), 'WW') FROM dual; > > Write any week number instead of '46' to the query. > > Mehmet > > > > 2011/11/15 Mohammed Iyad <[email protected]> > >> >> >> Hi >> >> We can get the week number using to_char function as follow: >> >> SELECT TO_CHAR(TO_DATE('12/11/2011','DD/MM/YYYY'),'WW') >> FROM DUAL >> >> but is their a function I could give it week number return the first date >> of given week >> >> Best Regards, >> Iyad >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en >> > > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
