I would like to set the Default value for a column to Current Time + 6hrs

Question

I have a column in an Sql server express table called DepTime which has a Time data type.

I would like to set the Default value for this column to Current Time + 6hrs.

How can I do this.

Thank you

What db software are you using? – EWit Feb 18 '15 at 18:49 — EWit, Feb 18 '15 at 18:49
Server Express edition with advanced tools – frustrationmultiplied Feb 19 '15 at 20:25 — frustrationmultiplied, Feb 19 '15 at 20:25

score 0 · Accepted Answer · answered Feb 18 '15 at 21:32

here is an example for a temporary table:

CREATE TABLE #tmp (
   test varchar(30),
   DepTime datetime  DEFAULT DATEADD(hour, 6, GETDATE())
);

or if you already have a table:

ALTER TABLE SomeTable 
   ADD CONSTRAINT DF_SomeTableSomeName 
   DEFAULT DATEADD(hour, 6, GETDATE()) FOR DepTime;

1 Answers1