title: Datepart week function wont work Please need assistance
body: <p>The table I am trying to use is </p>
  
  <pre><code>create type Rehearsal_ty as object
  (RehID char(4),
  RLocation add_ty,
  Attendance varchar2 (100),
  RDate date)
  
  create table Rehearsal_tbl of Rehearsal_ty
  </code></pre>
  
  <p>The select statement I am trying to use can't get it to work </p>
  
  <pre><code>SELECT rehid, DATEPART(wk,rdate)
  from Rehearsal_tbl
  
  SELECT DATEPART (ww,rdate())
  FROM Rehearsal_tbl;
  </code></pre>
  
  <p>please help 
  really stuck </p>