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 vote199 views1 answer
Mysql custom sort order
SQL
1 vote205 views1 answer
Mysql workbench in ubuntu 14.04
SQL
11 votes179 views1 answer
Oracle view ddl
SQL
0 vote184 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote203 views1 answer
SQL Server date literal
SQL
2 votes184 views1 answer
Wait delay in sql server
SQL
0 vote269 views1 answer
Mysql readable output
SQL
0 vote189 views1 answer
Timestamp(0) postgresql
SQL
2 votes230 views1 answer
Datetrunc
SQL
1 vote202 views1 answer
Get parameter value in mysql trigger
SQL