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.

• GETDATE function [Date and time]
• CURRENT TIMESTAMP special value

The following statement returns the current date and time:

SELECT NOW( * );