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 vote117 views1 answer
Mysql workbench indent formatting
SQL
0 vote128 views1 answer
Postgres list tables and row counts
SQL
3 votes141 views1 answer
Sql datetime as date
SQL
1 vote122 views4 answers
Sequelize migration default value
SQL
0 vote81 views1 answer
Update row in sqlite python
SQL
1 vote123 views2 answers
Mysql order by date asc null last
SQL
0 vote193 views1 answer
Check user sql password from command line
SQL
34 votes155 views6 answers
Install mysql client ubuntu
SQL
1 vote180 views1 answer
SQL server query column yes or no
SQL
0 vote133 views1 answer
Power bi union columns
SQL