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'

Source: grepper.com

Similar codes

1 vote366 views1 answer
Order by oracle
SQL
6 votes346 views1 answer
Allsource oracle
SQL
0 vote455 views1 answer
Sqlite display data in separated columns
SQL
0 vote389 views2 answers
T sql null or empty string
SQL
0 vote389 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote398 views2 answers
Coursera spark sql max count
SQL
8 votes359 views1 answer
Oracle tablespace datafile max size
SQL
0 vote332 views1 answer
How many columns can be used for creating index?
SQL
0 vote358 views1 answer
Sql clear table
SQL
0 vote384 views1 answer
Oracle cpu metric
SQL