SQL

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

current date in sql

SELECT current_date FROM dual;-- oracle
SELECT GETDATE(); -- SQL SERVER
SELECT NOW() AS DATETIME;  -- Mysql

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 and time in sql

SELECT CURRENT_DATE from dual;