Determining date given week and year

Determining date given week and year

Post by Alexander Tarasu » Wed, 13 Oct 1999 04:00:00








You may need to adjust constant and date format depending on your local rules. Play with this formula.

---------------------------
Alexander Tarasul
MCSD,MCDBA,MCSE
Certified Borland Delphi Client Server Developer

http://pages.ripco.com/~shleym
SQL Answers at http://pages.ripco.com/~shleym/sql_answers.htm
---------------

    Hello!
      Can anyone suggest how I can determine the week beginning date
      given only the week number and year?

    Thanks!
    Rob

 
 
 

1. How to transfer year, week, day to date

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.

2. Looking for DB/2projects

3. Extracting week of the year from Date field

4. How come ODBC faster than OLE-DB:

5. Calculating week and year according to ISO 8601 - week.txt (0/1)

6. APPLET + DATAGATEWAY + MS SQL SERVER 6.5

7. HELP: First Day in Week Setting and First Week in Year Help

8. HELP!!! Problems with MSDTC.LOG file

9. Week : howto find the date of the first day of a week#

10. total records year-to-date and previous year

11. date this year vs. last year

12. Year to Date vs Year Ago problem

13. Compare income this year to same date last year