Re: Timestamp vs. Date Datatype
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: tracy.rahmlow@xxxxxxxx
- Date: Wed, 5 Oct 2005 08:34:33 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
