sql datetime now
snippet in sql

sql get date

user9415

SELECT GETDATE(); 

sql current date

user9735

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

Example
Return the current database system date and time:

SELECT GETDATE();

sql display today's date

user4946

SELECT getdate()

sql DATE = GETDATE()

user5742

CAST(GETDATE() AS DATE)

sql datetime now

user5018

SELECT GETDATE();