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 vote279 views2 answers
Create new table plsql
SQL
0 vote285 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote321 views1 answer
Mysql backup query
SQL
0 vote229 views1 answer
Denied
SQL
0 vote298 views1 answer
How we can perform acid Operations in sql with examples
SQL
4 votes279 views2 answers
Mysql show indexes on table
SQL
4 votes282 views1 answer
Oracle table statistics last analyzed
SQL
0 vote344 views1 answer
Mssql last day of month
SQL
22 votes282 views4 answers
Tsql rename table
SQL
0 vote326 views1 answer
How to locate pg_hba.conf file
SQL