Hello, I'm running Oracle 8.1.7 for Solaris. I want to impose a
constraint on one of my tables that no two dates can be stored that
are from the same day. That is, if a row contains the date 2-13-04
7:56 AM, I don't want anyone to be able to create a row with the date
2-13-04 11:26 AM. Ideally, it would be great if there's a column type
that just has day (but no time) information, but I can't seem to find
such a column type. Any advice on how I can make this constraint
work?
Thanks - Dave
Received on Fri Feb 13 2004 - 10:09:57 CST
