oracle date without time code example Example: oracle current date without time SELECT trunc(sysdate) FROM dual; -- returns a DATE 01/12/2021 00:00:00