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

24 votes139 views4 answers
Postgres remove database
SQL
0 vote139 views1 answer
St_buffer mysql
SQL
1 vote144 views1 answer
Raw query must include primary key
SQL
0 vote94 views0 answer
SQL
10 votes141 views2 answers
Sql rtrim
SQL
0 vote142 views3 answers
Group_concat sql server
SQL
0 vote145 views1 answer
Postgresql in vs any performance
SQL
1 vote147 views1 answer
Flask sqlalchemy default value
SQL
0 vote130 views2 answers
Find Overlapping sql
SQL
0 vote294 views1 answer
Dublicate row sql
SQL