Date-manupulation

From: Dirk Beelprez <dbeelpre_at_roularta.be>
Date: Mon, 30 Aug 1999 15:57:51 +0200
Message-ID: <7qe2o7$qa$1@news1.skynet.be>

Hello,

When I run the select-statement

select TO_CHAR( NEXT_DAY( to_date('30/08/1999','DD/MM/YYYY'),'THURSDAY')) from sys.dual

the answers is 02-SEP-99, which is alright.

Now, I only knows the weeknr in the year 1999.

When I use ww in my to_date-format

select TO_CHAR( NEXT_DAY( to_date('5351999','DWWYYYY'),'FRIDAY')) from sys.dual
( and i 've been trying several ways with WW)

i got the answer
something like

ERROR:
ORA-01820: format code cannot appear in date input format.

Is there a smilar way to do this ?

Thanks Received on Mon Aug 30 1999 - 08:57:51 CDT