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

1 vote105 views1 answer
Mysql check table exists
SQL
0 vote111 views1 answer
Example of sql querry result sepapreted by comma
SQL
11 votes116 views2 answers
How to import mysql database command line
SQL
0 vote114 views1 answer
Mysql dump for selected row
SQL
4 votes132 views2 answers
Oracle unlock account
SQL
1 vote138 views1 answer
Primary key reset in SQL database
SQL
0 vote100 views3 answers
Fetlife
SQL
0 vote106 views1 answer
Nvl2 syntax
SQL
0 vote107 views2 answers
Get item by composite primary key mysql
SQL
0 vote102 views1 answer
Add column to table with default value plsql
SQL