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,
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 ProductionReceived on Mon Apr 12 2010 - 05:22:39 CDT