GETDATE function [Date and time]

Returns the current year, month, day, hour, minute, second and fraction of a second.

 Syntax
 Returns
 Remarks
 See also
 Standards and compatibility
 Example