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 vote128 views1 answer
Oracle sql winter time change
SQL
2 votes180 views1 answer
How to create sql database
SQL
53 votes326 views6 answers
How to install mysql ubuntu
SQL
5 votes138 views1 answer
Commentaire table oracle
SQL
6 votes131 views2 answers
Mysql set primary key
SQL
0 vote139 views1 answer
Open postgresql.conf in centos
SQL
3 votes155 views2 answers
Enter mysql command line
SQL
0 vote144 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
4 votes153 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote135 views1 answer
Sql drop procedure if exists
SQL