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 vote236 views2 answers
Postgresql get last day of month
SQL
0 vote264 views1 answer
Sql date time query find
SQL
2 votes228 views1 answer
Oracle index size
SQL
0 vote256 views1 answer
Mysql zerofill
SQL
0 vote236 views1 answer
Oracle list subpartitions
SQL
-1 vote230 views1 answer
Mysql coalesce
SQL
0 vote230 views1 answer
What is the use of index in mysql table
SQL
1 vote395 views1 answer
Postgres convert text to number
SQL
0 vote250 views1 answer
Mysql best varchar length size
SQL
0 vote236 views1 answer
Postgresql import a database of gzip
SQL