Date / Timestamp to record when a record was added

Question

This question already has answers here:

How do I add a “last updated” column in a SQL Server 2008 R2 table? (2 answers)

Closed 5 years ago.

Does anyone know of a function as such that I can use to add an automatic date and timestamp in a column for when a user adds a record to the database table?

Answer 1

You can pass GetDate() function as an parameter to your insert query e.g

Insert into table (col1,CreatedOn) values (value1,Getdate())

Answer 2

You can use a datetime field and set it's default value to GetDate().

CREATE TABLE [dbo].[Test](
    [TimeStamp] [datetime] NOT NULL CONSTRAINT [DF_Test_TimeStamp] DEFAULT (GetDate()),
    [Foo] [varchar](50) NOT NULL
) ON [PRIMARY]

Answer 3

You can create a non-nullable DATETIME column on your table, and create a DEFAULT constraint on it to auto populate when a row is added.

e.g.

CREATE TABLE Example
(
SomeField INTEGER,
DateCreated DATETIME NOT NULL DEFAULT(GETDATE())
)

Answer 4

You can make a default constraint on this column that will put a default getdate() as a value.

Example:

alter table dbo.TABLE 
add constraint df_TABLE_DATE default getdate() for DATE_COLUMN

Answer 5

you can use DateAdd on a trigger or a computed column if the timestamp you are adding is fixed or dependent of another column