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 vote365 views1 answer
Sqlite trim
SQL
0 vote334 views1 answer
Sql include rows with 0 values
SQL
0 vote363 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes312 views1 answer
Get first 3 letters name in sql
SQL
0 vote334 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote335 views1 answer
How to move a column to different spot mysql
SQL
1 vote324 views1 answer
Mysql limit results to 10
SQL
7 votes339 views1 answer
Alter sequence set current value oracle
SQL
0 vote321 views1 answer
Laravel eloquent get generated sql
SQL
3 votes299 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL