sql server current date

1GETDATE()
2

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

1SELECT CAST( GETDATE() AS Date ) ;

1GETDATE()

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

1Add GETDATE() in sql query where you want to pass current timestamp.
2
3Example
4Return the current database system date and time:
5
6SELECT GETDATE();