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

2 votes193 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote182 views1 answer
Alter add syntax
SQL
1 vote177 views1 answer
How to change owner in postgres
SQL
9 votes214 views1 answer
Identity insert on sql server
SQL
0 vote240 views1 answer
Two inner joins sql
SQL
0 vote283 views1 answer
Sqlite woth cmake
SQL
0 vote183 views1 answer
Left join vs inner join performance
SQL
0 vote202 views1 answer
Replace string in whole database mysql stackoverflow
SQL
7 votes162 views1 answer
Forge server hosting
SQL
0 vote185 views1 answer
Logtash mysql cofiguration file
SQL