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 vote282 views1 answer
Connect by query in oracle
SQL
2 votes257 views1 answer
Oracle cpu per session
SQL
0 vote282 views1 answer
Mysql 8 geo to json
SQL
0 vote276 views1 answer
Helptext in sql
SQL
0 vote254 views1 answer
Mysql installer no packages found
SQL
0 vote271 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote301 views1 answer
Bigrock database connection string
SQL
3 votes281 views5 answers
Foreign keys
SQL
47 votes325 views6 answers
Add column mysql
SQL
1 vote262 views1 answer
Oracle rolling back
SQL