SQL 2008 default date needs to be 1900-01-01
I am trying to set the "Default Value or Binding" to
1900-01-01
on SQL server 2008
I am getting the error:
Error Validating the default for column 'CreateDate'
Do you want to cancel your changes?
I don't want to use getdate() for my default. How can I do this?
1900-01-01
on SQL server 2008
I am getting the error:
Error Validating the default for column 'CreateDate'
Do you want to cancel your changes?
I don't want to use getdate() for my default. How can I do this?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
try:
ALTER TABLE YourTable
ADD CONSTRAINT [DefaultConstraintDT] DEFAULT ('1900-01-01') FOR [YourColumn_CreateDate]
ALTER TABLE YourTable
ADD CONSTRAINT [DefaultConstraintDT] DEFAULT ('1900-01-01') FOR [YourColumn_CreateDate]
Premium Content
You need an Expert Office subscription to comment.Start Free Trial