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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 14 Dec 1999 22:06:07 +0800
Message-ID: <38564ECF.1B23@yahoo.com>

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

One of the format masks (I think IW) is the week number of the year which will allow you do to the conversion you are after just using the normal to_date, to_char

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 14 1999 - 08:06:07 CST