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