Re: How to transfer year, week, day to date

On 10 Jun 2002 04:45:46 -0700, mraap_at_yahoo.com (Marcel Raap) wrote:

>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.

First, you have to specify how you handle the first week of the year and of the first day of the week. But IME, the best place for data is in a table.

-- 
Mike Sherrill
Information Management Systems