Datepart week function wont work Please need assistance

Question

The table I am trying to use is

create type Rehearsal_ty as object
(RehID char(4),
RLocation add_ty,
Attendance varchar2 (100),
RDate date)

create table Rehearsal_tbl of Rehearsal_ty

The select statement I am trying to use can't get it to work

SELECT rehid, DATEPART(wk,rdate)
from Rehearsal_tbl

SELECT DATEPART (ww,rdate())
FROM Rehearsal_tbl;

please help really stuck

Answer 1

(UPDATED) Looks like the Oracle documentation was incorrect - here's a version which works. You can test it out here: http://sqlfiddle.com/#!4/77080/7

select RehID, to_char(rdate, 'IW') as IsoWeekChar
from Rehearsal_tbl;

.

select RehID, to_char(rdate, 'WW') as IsoWeekChar
from Rehearsal_tbl;

.

select RehID, to_number(to_char(rdate, 'IW')) as IsoWeekNumeric
from Rehearsal_tbl;

.

select RehID, to_number(to_char(rdate, 'WW')) as OraWeekNumeric
from Rehearsal_tbl;