Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to transfer year, week, day to date
Marcel Raap wrote:
> Hi,
>
> I need a SQL-statement (or PLS/SQL function) that accepts a year, a
> week number and a day number as input and returns a date.
>
> I thought of doing it like this:
>
> select to_date('1-24-2002', 'D-WW-YYYY')
> from dual;
>
> but for some reason this is not allowed in SQL*Plus.
>
> Anyone suggestions???
>
> Thanks!
>
> Marcel.
I am not aware of any function in Oracle capable of doing this. I'll be interested in seeing other postings. I suspect you may need to do the math yourself.
Daniel Morgan Received on Mon Jun 10 2002 - 10:55:30 CDT