Re: Timestamp vs. Date Datatype

Tracy,

I'm not privy to Oracle's decisions, so the best I can do is guess:
> Why did Oracle introduce the timestamp datatype vs. enhancing the date
> datatype's precision?

     Backward compatability?
>Is everyone migrating to the timestamp datatype?

     No
>Why would anyone want to use the date datatype anymore?

     Often only the date is significant. In that situation, don't store the timestamp.

     Indexing date-only date fields is much more efficient.
> It appears to me that the timestamp does everything that the date datatype does and more.

     You are correct. However, I haven't had a situation where subsecond information was relevant.
>The granularity and computations that can be performed with the timestamp
> datatype appear to be much better.
> Thanks

     Thank you for raising this important topic.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l