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.