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()