Need to add constraint: date plus 10 days

Question

I'm trying to add a constraint to a table so that it displays one of the columns as the current date plus 10 days. Here's what I've tried so far (I'm very new to SQL):

ALTER TABLE         orders
ADD CONSTRAINT  default_date
DEFAULT         DATEADD (DAY,10,required_date) FOR required_date

Halp!

Edit: I've also tried this now:

ALTER TABLE         orders
ALTER COLUMN        required_date
ADD CONSTRAINT      required_date_plus_ten
DEFAULT             DATEADD (DAY,10,required_date)

Edit: Thanks to ypercube & my classmate. The final code is:

ALTER TABLE       orders
ADD CONSTRAINT    default_date
DEFAULT           (DATEADD (DAY,10,'required_date')) FOR required_date;

Are you sure your want a constraint? Perhaps you want a calculated column in a view (returning some existing column plus 10 days)... — BellevueBob, Nov 23 '12 at 22:44
I'm using the Microsoft SQL management server. I'm doing a school project and it says to add the constraint: 'required date' (the column name I'm adding the constraint to) should default to today's date plus 10 days. — isolatedhowl, Nov 23 '12 at 22:48
then yes the term is being used very loosely and it's actually a calculated field. Also the constraint can't actually be against the 'current' date or it will never be reached. — Michael Durrant, Nov 23 '12 at 23:11

score 3 · Accepted Answer · answered Nov 23 '12 at 23:13

3

The syntax in SQL-Server, for adding a DEFAULT value to an existing column is:

ALTER TABLE     orders
ADD CONSTRAINT  required_date_plus_ten
DEFAULT         DATEADD(day, 10, GETDATE())
FOR             required_date ;

Tested in SQL-Fiddle

answered Nov 23 '12 at 23:13

ypercubeᵀᴹ

113,259
19
174
235

Yes perfect thanks. My classmate has also helped me out with this. I'll post my final code. – isolatedhowl Nov 23 '12 at 23:14

Need to add constraint: date plus 10 days

1 Answers1

Linked