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 vote139 views2 answers
Android sqlite tutorial for beginners
SQL
2 votes151 views1 answer
Add default sql server
SQL
1 vote148 views2 answers
Mysql select tables with name like
SQL
0 vote146 views1 answer
Table values functions in SQL
SQL
7 votes133 views1 answer
Forge server hosting
SQL
0 vote156 views1 answer
Mysql drop vs delete
SQL
4 votes150 views1 answer
Mysql not equal
SQL
0 vote148 views1 answer
Search db for table name
SQL
4 votes153 views3 answers
Sqlite show columns
SQL
11 votes150 views2 answers
Having clause in sql
SQL