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 <iya...@gmail.com>
>
>
> 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
>
--
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
