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

4 votes274 views4 answers
Oracle tablespace tables list
SQL
0 vote246 views1 answer
How to see the query of a view in mysql
SQL
1 vote257 views1 answer
Mysql not supported auth mode
SQL
0 vote274 views1 answer
Print hello world in plsql
SQL
2 votes265 views1 answer
Q operator in sql
SQL
13 votes266 views6 answers
Current date sql
SQL
0 vote258 views1 answer
Casterar postgres
SQL
1 vote267 views1 answer
Import mysql dump database command line linux
SQL
0 vote248 views1 answer
Postgresql inline table
SQL
0 vote293 views3 answers
Postgres date difference seconds
SQL