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 vote317 views1 answer
How to check which sp is running in sql server
SQL
2 votes316 views1 answer
Postgresql add entry to table
SQL
0 vote319 views1 answer
Ora 00001 error catch plsql
SQL
11 votes772 views4 answers
Reset identity column values in sql server
SQL
0 vote321 views2 answers
Postgresql get long running queries
SQL
0 vote419 views1 answer
Stop and start mysql
SQL
0 vote319 views1 answer
Sql get table last modified time
SQL
16 votes353 views2 answers
Mysql date between two dates
SQL
1 vote345 views1 answer
Is sql fast
SQL
9 votes343 views5 answers
Sql delete duplicate rows but keep one
SQL