SQL

date less than current date sql

SELECT * FROM table_name WHERE date_field >= NOW();

sql constraint to check date less than current date

ALTER TABLE yourTable
	ADD CONSTRAINT yourDateTimeColumn CHECK (yourDateTimeColumn < GetDate() );

sql constraint date greater than

alter table foo
   add constraint check_dates check (from_date < to_date);