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

12 votes150 views6 answers
Distinct in sql server
SQL
0 vote134 views1 answer
Running percentage of total postgres
SQL
3 votes117 views1 answer
How to find names includes in sql
SQL
2 votes130 views1 answer
Capitalize 1st letter in sql server
SQL
3 votes168 views6 answers
Jwt laravel
SQL
0 vote127 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote115 views1 answer
With_for_update sqlalchemy
SQL
25 votes115 views5 answers
Date in mysql
SQL
0 vote144 views1 answer
Sqlite3 pragma foreign keys
SQL
1 vote130 views1 answer
Liquibase alter column type / length
SQL