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


I have a requirement to enforce Uniqueuness on a DATE Column for a day only

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

Other related posts: