GETDATE Function

Returns the current date and time, in the local time zone.

Syntax

GETDATE()

Return Value

A date string formatted like "2016-07-23 22:12:55.652".

Example

PRINT GETDATE();