Date Timestamp to record when a record was added to the table

Question

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

User · Answer

You can pass GetDate   function as an parameter to your insert query e g  Insert into table  col1 CreatedOn  values  value1 Getdate

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

[sql] Date / Timestamp to record when a record was added to the table?

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008

Examples related to sql-server-2005