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

15 votes284 views2 answers
How to drop database name in postgresql
SQL
0 vote316 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote299 views1 answer
Sql find leading space
SQL
2 votes271 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote312 views1 answer
Ajax error exception handeling
SQL
2 votes297 views1 answer
Oracle drop table free up space
SQL
0 vote300 views2 answers
Mysql regexp match word
SQL
3 votes282 views2 answers
Mysql add 2 hours
SQL
0 vote337 views2 answers
Wordpress change url after migration mysql query
SQL
2 votes254 views1 answer
Sql select in list
SQL