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 vote113 views1 answer
Name '_mysql' is not defined
SQL
3 votes124 views1 answer
Laravel database Using Named Bindings
SQL
0 vote71 views1 answer
Mysql insert with foreign key
SQL
4 votes107 views1 answer
Data types in sql
SQL
0 vote108 views1 answer
Dump only schema
SQL
0 vote107 views1 answer
Json_remove mysql
SQL
0 vote126 views1 answer
Oracle chain step succeeded
SQL
0 vote114 views1 answer
Java sql connection
SQL
1 vote135 views1 answer
Mysql select all and rename one
SQL
3 votes118 views2 answers
Mysql config user password
SQL