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'

Source: grepper.com

Similar codes

0 vote136 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
2 votes120 views1 answer
Oracle to_char number format percentage
SQL
2 votes116 views1 answer
Db.relationship sqlalchemy flask
SQL
1 vote112 views1 answer
Oracle grant on all tables in schema
SQL
2 votes112 views1 answer
Mysql find tables with name
SQL
2 votes113 views1 answer
Mysql select default if null
SQL
0 vote146 views1 answer
How to get table id sequence postgres
SQL
0 vote138 views1 answer
Mysql get nth highest
SQL
0 vote115 views1 answer
Oracle date summer time
SQL
-1 vote124 views1 answer
Brisanje dupliranih konatakata
SQL