Sql datetime now

This article is tagged with: Sql datetime now and mysql

sql server current date

GETDATE()

sql DATE = GETDATE()

CAST(GETDATE() AS DATE)

sql datetime now

SELECT GETDATE();

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();

sql display today’s date

SELECT getdate()

sql get date

SELECT GETDATE();

This article is tagged with: Sql datetime now and mysql