Unique Key enforcement on a DATE Column for DAY (mm/dd/yy)

Greetings


I have a requirement to enforce Uniqueuness on a DATE Column for a day only
(mm/dd/yy(yy)

Should allow users to enter data only once in a day,  Can it be enforced
through a Unique constraint

Need to implement this in Oralce 8i, 9i, 10g

-- 
Regards & Thanks
BN

Other related posts: