While extract does the job very nicely, trunc was altered in 10g to work with timestamp as will as date.