sql get today's date code example

Example 1: get current date sql

SELECT getdate(); -- Get Current date in SQL Server

Example 2: sql current date

Add GETDATE() in sql query where you want to pass current timestamp.

Example
Return the current database system date and time:

SELECT GETDATE();

Example 3: sql display today's date

SELECT getdate()

Example 4: current date in sql

SELECT CURRENT_DATE from dual;

Example 5: how to retrive the today date sql

select * from datetimes 
where dtm >= cast((now()) as date)
and dtm < cast((now() + interval 1 day) as date)
;