SQL

sql where date today sql

select * from tbl_name 
where cast(datecolumn as Date) = cast(getdate() as Date)

-- or if getdata does not exists
select * from tbl_name 
where cast(datecolumn as Date) = cast(now() as Date)
-- or if date is incompatible with int
select * from tbl_name 
where datecolumn = 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();

current date in sql

SELECT CURRENT_DATE from dual;