SQL> select rownum-1 power_of2 2 , to_char(trunc(sysdate,'YYYY')-1+power(2,rownum-1), 3 'DD-MON-YYYY DAY') magic_day 4 from dual connect by level <=9; POWER_OF2 MAGIC_DAY ---------- --------------------------------------------------------- 0 01-JAN-2006 SUNDAY 1 02-JAN-2006 MONDAY 2 04-JAN-2006 WEDNESDAY 3 08-JAN-2006 SUNDAY 4 16-JAN-2006 MONDAY 5 01-FEB-2006 WEDNESDAY 6 05-MAR-2006 SUNDAY 7 08-MAY-2006 MONDAY 8 13-SEP-2006 WEDNESDAY 9 rows selected.Interesting coincidence - there are only 3 days of week: SUNDAY, MONDAY and WEDNESDAY.
BTW. Does anybody know if is it possible to turn off these automatic <br /> tags in beta blogger?
Paweł
No comments:
Post a Comment