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 Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to