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 vote233 views1 answer
Joomla execute raw sql
SQL
0 vote198 views1 answer
Compression of dabatase mysqldumo
SQL
7 votes204 views2 answers
Postgres concat
SQL
16 votes187 views1 answer
Mysql mediumint max value
SQL
0 vote222 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote203 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote189 views1 answer
Rename constraint postgresql
SQL
1 vote180 views1 answer
Get rows affected mysql python
SQL
0 vote182 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote232 views1 answer
Cahnge column name apex oracle
SQL