GETDATE
Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of Lyftron is running.
Syntax
GETDATE ( )
Return types
datetime
Example
SELECT GETDATE() as [now];