I'm trying to create a table writing in SQL and I need to validate the 'Date of Birth' field
'Players must be over 16 years of age'
So how should I validate this. my table name is : Players
field name is DOB and the datatype is 'DATE'
I tried this 'ALTER TABLE Players SET CHECK DOB >= (16 * 365.25) ;
ERROR "Players must be above 16 years of age."
But it doesn't work. Please help :)