SQL

sql for date greater than

SELECT * FROM ATable WHERE DateField >= Convert(datetime, '2021-12-17 18:25:29')

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);