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 vote191 views1 answer
Postgres declare variable
SQL
0 vote206 views1 answer
Disable database droping sql
SQL
4 votes186 views1 answer
What are the data types in sql
SQL
12 votes204 views4 answers
Mysql version
SQL
15 votes245 views5 answers
Show tables in oracle
SQL
0 vote188 views1 answer
How to reset AI in sql
SQL
0 vote209 views1 answer
Mysql begin statement
SQL
4 votes183 views3 answers
Create database in mySQL
SQL
4 votes197 views2 answers
Postgre sql create table
SQL
3 votes215 views1 answer
Define REGEXP?
SQL