getdate() returns the timestamp associated with current transaction. This is an alias of now().
Date & Time Manipulation section of the SQL Reference Chapter.