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

5 votes186 views2 answers
Oracle list columns
SQL
0 vote222 views1 answer
Radius search with point data in mysql
SQL
0 vote172 views1 answer
How to see password mysql vestacp
SQL
3 votes156 views2 answers
Mysql create database
SQL
2 votes201 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote187 views2 answers
Dbms transaction tutorialspoint
SQL
5 votes189 views1 answer
Oracle generate list of dates in between a date range
SQL
5 votes172 views2 answers
Oracle apex debug mode
SQL
0 vote166 views1 answer
Show the colums of table sql
SQL
1 vote175 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL