how to insert datetime automatically in database

go on this link

0

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.

0

saurabh mittal12y ago

        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.

0

Jignesh Trivedi12y ago

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.

0

Abhay Shanker12y ago

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

0