oracle get only 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
SELECT trunc(sysdate) FROM dual; -- returns a DATE 01/12/2021 00:00:00