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

14 votes332 views1 answer
Oracle new column
SQL
0 vote336 views1 answer
Oracle current timestamp insert statement
SQL
0 vote311 views1 answer
Sqlalchemy query join many to many
SQL
0 vote310 views1 answer
Postgresql select fast check no rows
SQL
7 votes320 views1 answer
Oracle reset sequence
SQL
0 vote318 views1 answer
Hibernate xml property MySQL url, username and password
SQL
5 votes316 views3 answers
Oracle list columns in schema
SQL
0 vote320 views1 answer
T sql cursor tr
SQL
3 votes306 views5 answers
Mysql get last inserted id
SQL
0 vote318 views1 answer
Mysql select statement after index
SQL