ASP.NET VB how to add/use timestamp on sqldatabase

Question

I am currently developing a webpage, and I want to add date&time to my database whenever there is an entry on the database.

What meaning would this datatime entry have? When would this entry change if at all? — Oded
– Oded, Commented Feb 18, 2012 at 16:11
whenever there is an entry to the database, it automatically adds the current date & time when was that certain entry was made and had been successfully added to the database — jade calingin
– jade calingin, Commented Feb 18, 2012 at 16:16

Josh Darnell · Accepted Answer · 2012-02-18 17:21:28Z

2

Create a column of type datetime with a default value of getdate()

Each time an insert is added, it should stamp it with the current date/time

SQL code to add the column:

ALTER TABLE {tablename} 
ADD {column_name} {DateTime} {NULL|NOT NULL} DEFAULT {getdate()}

edited Feb 18, 2012 at 17:21

Josh Darnell

11.5k9 gold badges40 silver badges66 bronze badges

answered Feb 18, 2012 at 16:07

Jeff

1,6593 gold badges22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

jade calingin Over a year ago

can you guide me on how to do that? sorry, cause I'm new to this one :)

Jeff Over a year ago

I added to the answer - I am not sure the specifics of your database though. I am assuming MSSQL - The above should work if that is the case. Then all yo would have to do is read from the datetime to see when the row was inserted.

jade calingin Over a year ago

so I just add a column that has a timeStamp data type? then it will automatically generates the date&time for every entry?

jade calingin Over a year ago

is there any special coding to do in order to get that data type to work?

jmoreno Over a year ago

This works for INSERTS if the value is not set to null. It does not work for updates or where the column is included amoung the values (either explicitly by column list or implicitly by insert into select *)

|

Collectives™ on Stack Overflow

ASP.NET VB how to add/use timestamp on sqldatabase

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related