Re: SQL: Getting all Monday's in a year

In article <8jHTwKS00VBKM1J1Nj_at_andrew.cmu.edu> Serge Taylor <st0u+_at_andrew.cmu.edu> writes:
>Is there some easy way to find out the dates of all Monday's in a
>given year. I'm trying to avoid generating every date and then culling.
>Thanks,
>Serge Taylor
>CMU
Easy!!!

SELECT
   TO_DATE ('02-JAN-95') + (ROWNUM - 1) * 7 FROM
   fake table with at least 52 rows
WHERE
   ROWNUM <= 52;

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!" Received on Thu Mar 09 1995 - 13:33:17 CET