Change datetime to date


select TRUNC(DateTimeField)

//This returns only the DATE part..

Oracle/PLSQL: Trunc Function (with dates)