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 vote213 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote199 views1 answer
Oracle synonym procedure dblink
SQL
1 vote203 views1 answer
Mysql select and count left join
SQL
0 vote226 views1 answer
How to fetch data from database in sql
SQL
9 votes196 views1 answer
Mysql check date range
SQL
0 vote203 views1 answer
Set column in all row mysql
SQL
0 vote203 views1 answer
Select into table variable
SQL
0 vote274 views2 answers
Mysql insert rows to another database
SQL
0 vote208 views1 answer
Authentication modes in sql server
SQL
1 vote196 views1 answer
Postgres set column based on another column
SQL