Answers for "oracle get only date without time"

SQL
2

oracle current date without time

SELECT trunc(sysdate) FROM dual;		-- returns a DATE  01/12/2021 00:00:00
SELECT to_char(sysdate, 'DD/MM/YYYY') FROM dual; -- returns a string '01/12/2021'
Posted by: Guest on May-08-2021

Code answers related to "oracle get only date without time"

Code answers related to "SQL"

Browse Popular Code Answers by Language