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 vote106 views1 answer
How to see the content of tables in pgadmin
SQL
1 vote177 views1 answer
Oracle activate job
SQL
0 vote166 views1 answer
Postgresql inheritance
SQL
16 votes173 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes155 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
-1 vote153 views5 answers
Online sql to linq generator
SQL
7 votes155 views1 answer
Oracle pagination query offset
SQL
0 vote158 views1 answer
How to check replication lag in mySQL
SQL
0 vote109 views1 answer
Get all stored procedures in sql server
SQL
1 vote154 views1 answer
Mysql query where in select
SQL