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:

> 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
Production
Received on Tue Apr 13 2010 - 01:07:31 CDT

Original text of this message