Sql

Search

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'

Comment

PREVIOUS	NEXT

Code Example
Sql :: postgresql convert text to float
Sql :: postgresql reset auto increment
Sql :: postgresql drop primary key constraint
Sql :: how to check all scheduled jobs in oracle
Sql :: postgres delete database
Sql :: mysql increment value by 1 in update
Sql :: postgresql if 0 then 1
Sql :: sql convert datetime to year month
Sql :: mysql monthname
Sql :: postgresql alter column nullable
Sql :: pip install mysqlclient error
Sql :: pyodbc connect to sql server
Sql :: oracle alter sequence nextval
Sql :: postgres delete last row
Sql :: sql change table name
Sql :: mysql delete binlog
Sql :: sql throw error
Sql :: sql copy table structure
Sql :: oracle aleter trigger ora-01031
Sql :: oracle export trigger ddl
Sql :: add primary key to existing table sql
Sql :: oracle activate job
Sql :: my sql version
Sql :: mssql get running queries
Sql :: mysql show all tables
Sql :: helptext in sql
Sql :: mysql best varchar length size
Sql :: sql query inline if
Sql :: sql server 2008 first and last day of month
Sql :: postgres convert text to number

Search

SQL

oracle current date without time

ADD CONTENT