sql server current date
snippet in sql

sql get date

user943

SELECT GETDATE(); 

sqlserver now

user2526

getdate() 

getutcdate()