DateTime Functions

 GETDATE()

DATEADD()

DATEDIFF()

DATEPART()

Datename()

NOW()

CURRENTDATE()

CURRENTTIME()

DATE()

EXTRACT()

CONVERT()

FORMAT()

Day()

Month()

Year()

Sysdatetime()

Sysdatetimeoffset()

Sysutcdatetime()

Gettutdate()

Switchoffset()

Todatetimeoffset()

CurrentTimeStamp()