sql query check if current datetime is less than datetime column code example

Example: sql constraint to check date less than current date

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