A date is unique if a row with that key gets inserted only once. For example to record a newsletter generate no more than once per day. If you had any table with no row or one row per day the date would make a good primary key.