how do i do an insert with DATETIME now inside of SQL server ...

Now in C#. I am running this below from the query editor in sql server mgmt studio. Is there anyway to pass in the current date time in this query below. INSERT ...

stackoverflow.com