NOW( [ * ] )

TIMESTAMP

NOW is equivalent to the GETDATE function and the CURRENT TIMESTAMP special value. NOW(*) and NOW() are equivalent constructions.

Each instance of the NOW function in a request is evaluated at most once. Multiple instances of NOW in the same request may or may not share the identical TIMESTAMP value.

• CURRENT TIME special value
• CURRENT TIMESTAMP special value
• CURRENT UTC TIMESTAMP special value
• DATE data type
• DATE function [Date and time]
• DATETIME data type
• DATETIME function [Date and time]
• DATETIMEOFFSET data type
• Expressions
• GETDATE function [Date and time]
• ISDATE function [Data type conversion]
• SMALLDATETIME data type
• TIME data type
• TIMESTAMP special value
• TIMESTAMP data type
• UTC TIMESTAMP special value

The following statement returns the current date and time:

SELECT NOW( * );