if the datatype of your date column in your database is datetime then in button click you can use directly
DateTime.Now
or if it is varchar type you can pass like this
DateTime.Now.ToString()
or if you write stored procedure for inserting the record in stored procedure you can write like
getdate() function in sqlserver returns the current date and time
getdate()