if you include the fn now function, there are seven ways i know of to get the current datetime; there's a few threads around that points out that a potential candidate should know how to get the current datetime, and anyone with a bit of expereince should know there's more.
I believe there is at least one dmv you can select a column from that returns the datetime too, but i don't remember offhand.
SELECT CURRENT_TIMESTAMP,
{fn NOW()},
Getdate(),
Getutcdate(),
SYSDATETIME(),
SYSUTCDATETIME(),
SYSDATETIMEOFFSET()
Lowell