Re: Is there a column-data-type restricted to truncated date format?
From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Tue, 13 Apr 2010 08:07:31 +0200
Message-ID: <biojgcg95va$.1qj9u0s716f3y.dlg_at_40tude.net>
Am Mon, 12 Apr 2010 06:31:35 -0700 (PDT) schrieb Ed Prochak:
Date: Tue, 13 Apr 2010 08:07:31 +0200
Message-ID: <biojgcg95va$.1qj9u0s716f3y.dlg_at_40tude.net>
Am Mon, 12 Apr 2010 06:31:35 -0700 (PDT) schrieb Ed Prochak:
> combined date/time type. There is no truncated date type. What's
> stopping you from using a check constraint?
>
OK, that's a possibility. But the calculated column seem me to be the
approach with the most benefit.
-- Norbert Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionReceived on Tue Apr 13 2010 - 01:07:31 CDT