How To Get The System Date And Time Into Database

  Hi,

I m using ASP.NET with C#.
I m having one field which should store the datetime of the system.

The datetime should be automatically stored for that entry when the user submits that record on the click event.
Then it should display the date time on the gridview from database.

I m using sqlserver 2005 and i have created the stored procedure for the insert command.

This
is the sample sp what should be written here to insert system date time
automatically when the user submits the asp.net form ?
Is there any code for writing directly in stored procedure or asp.net coding page... 
 

ALTER PROCEDURE [dbo].[StoredProcedure1]

@salesid INT OUTPUT,
@salesdate datetime,
@customername varchar(20)

AS
BEGIN
SET NOCOUNT ON

BEGIN
INSERT INTO sales (customername)
VALUES (@customername)
SELECT @companyid = SCOPE_IDENTITY()
END

SET NOCOUNT OFF
END Thanxs in advance...