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'

Similar codes

0 vote192 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
28 votes219 views4 answers
Mysql delete database
SQL
0 vote208 views2 answers
Advantages of stored procedures sql
SQL
-1 vote224 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote194 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote199 views1 answer
How to find sql server installation folder
SQL
10 votes268 views6 answers
Mysql set root password
SQL
0 vote216 views1 answer
Amount of entries in a table psql
SQL
1 vote281 views1 answer
Connect to mysql database ubuntu
SQL
9 votes246 views1 answer
No sql
SQL