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 vote323 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote356 views1 answer
Sqlcl format
SQL
0 vote313 views1 answer
How to find database collation in postgres
SQL
0 vote334 views1 answer
Sql reverse order of results
SQL
0 vote308 views1 answer
How to count with except in psql
SQL
3 votes309 views1 answer
How to remove characters from string in mysql
SQL
0 vote351 views1 answer
How to move a columns location in mysql
SQL
0 vote366 views2 answers
Identity syntax in sql
SQL
0 vote356 views1 answer
Python sql last insertend
SQL
0 vote366 views1 answer
Bigrock database connection string
SQL