Have a look at trunc/round(CreationDate, 'DAY'): http://download-west.oracle.com/docs...tion.htm#78667