how to insert datetime automatically in database

Question

i want to insert datetime in database when user register for my site then when will he registered that system time i want to insert automatically using c#

Munesh Sharma · Answer

go on this link

Pradip Pandey · Answer

Simply change your table design means select the table, right click on it then click on design. Table design window will open. Select the field and write GetDate() or GetUtcDate() in the Default Value or Binding in General option in Column Properties for Sql Server 2012. Hope this will help you.

saurabh mittal · Answer

Hi just put (GETDATE()) with in Default Value or Binding in column properties in sql server. it will automatically take date. no need to enter in c# coding.

Jignesh Trivedi · Answer

hi, you can also use Default constrain for this.... try... Create Table #test ( id int, mydate datetime default getdate() ) insert into #test (id) values(1) insert into #test (id) values(2) --check result select * from #test In this way you need not worried in C# code... hope this will help you.

Abhay Shanker · Answer

In SQL Server it can be done as: Insert into TableName ( DateField ) VALUES ( GetDate ()) From C# coding DateTime dt= DateTime.Now; save date in the format of yyyy-MM-dd hh:mm:ss

how to insert datetime automatically in database

Answers (5)