Is there a column-data-type restricted to truncated date format?

From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Mon, 12 Apr 2010 12:22:39 +0200
Message-ID: <1pdm3n4ex8xpw.e8v5gu9fab14.dlg_at_40tude.net>



Hi,

for creating a unique index with a date-column A_DATE I'm using a calculated column X_DATE as (trunc(A_DATE)):

CREATE UNIQUE INDEX UX_A_TABLE
  ON A_TABLE (
    ...,
    X_DATE
  )
/

Using A_DATE in UX_A_TABLE would fail if someone would use sysdate two times a day.
Is there a column-data-type restricted to truncated date format?

-- 
Norbert
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
Received on Mon Apr 12 2010 - 05:22:39 CDT

Original text of this message