Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date Check Constraint

890667Sep 30 2011 — edited Oct 1 2011
Can I please have some help with a check constraint.

The Table is called TITLE and the attribute is TI_RELDATE (a date). I am wanting to make sure that it is between 1930 and today's date.
Is it something like this:

CONSTRAINT TITLE_ck_TI_RELDATE CHECK (TI_RELDATE is between 1930 and GETDATE())

Canning
This post has been answered by Solomon Yakobson on Sep 30 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2011
Added on Sep 30 2011
7 comments
6,480 views