SQL

mssql current date

SELECT CAST( GETDATE() AS Date ) ;

sql server date now

select cast(getdate() as date)

sql server current date

GETDATE()

get current date sql

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

current date sql

INSERT INTO my_table (last_updated) VALUES(NOW());
INSERT INTO my_table (last_updated) VALUES(sysdate);	-- Oracle
INSERT INTO my_table (last_updated) VALUES(getdate());	-- SQL Server

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();

Current sql date

SELECT CURDATE();

how to to get current date in sql

SELECT CURRENT_DATE from dual;