Change datetime to date 18. Oktober 2011 Ralf Datenbanken SELECT TRUNC(DateTimeField) //This RETURNS ONLY the DATE part.. Oracle/PLSQL: Trunc Function (with dates)