Re: Getting the first day of a calendar week (Date Format)

Try some variation of:
select trunc(sysdate,'WW') from dual;

hth
cc

Tom Talberg wrote:

> Hi everybody,
>
> i have a table-column which stores the calendar week and the year. Its a
> number(4) field, 2 digits for the week and 2 for the year. What i want to do
> is to transfer this data into another tables column (type date). But Oracle
> 8.0.5 doesn't accept dates only containing the week and the year. Therefore
> i search for a way to determine the first day of the week to store the date
> of the first day of the week in the new table.
>
> Thanks in advance for any hints or solutions.
>
> Robert
Received on Tue Dec 14 1999 - 15:41:41 CST