SQL Date Conditions -
how create date condition user add date after specific time adding limit date value?
example:
i need create hire_date
requires user enter date after 01/12/1980.
most databases support ansi standard check
constraint:
alter table t add constraint chk_t_hiredate check (hiredate > date '1980-12-01');
note date
keyword not needed (or allowed) in databases.
Comments
Post a Comment