This content has been marked as final. Show 2 replies
Performance has no role to play in selecting which data type to use.1 person found this helpful
DATE in oracle can store the date value and the time value up to seconds.
Apart from this, TIMESTAMP can store fractional seconds also. TIMESTAMP WITh TIMEZONE can store zone data also..
So, you have to select datatype based on what data you want to store.. If you are interested only in date value (plus time upto seconds), there is NO NEED to use TIMESTAMP data type..
Use DATE when you have a choice.
I'm sure DATEs are more efficient than TIMSTAMPs (though I don't have any solid evidence). Also, DATEs require less storage space, and there are more functions available for manipulating DATEs. (These funtions usually work on TIMESTAMPs also, but they start by converting the TIMESTAMP to a DATE.)