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 vote175 views1 answer
Replace \n sql
SQL
0 vote216 views1 answer
Typical max-connect-errors mysql
SQL
3 votes186 views4 answers
Stop MySQL
SQL
0 vote184 views1 answer
Gcloud check sql
SQL
2 votes176 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote187 views1 answer
Base64 encode sql server
SQL
5 votes178 views1 answer
Mysql created at yesterdau
SQL
2 votes177 views1 answer
How to select first row of database sql
SQL
11 votes198 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote171 views1 answer
Mysql group rows with same value
SQL