Re: Just want day but no time information

D. Alvarado wrote:

> 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

Store information as TRUNC(<date>) and place a unique constraint on the column.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)