Is there a DATEPART function for Oracle like there is in SQL? If so, how does it work with the (sysdate)? An example of a "dateweek" statement would be very helpfull.

Thanks