Date vs Timestamp vs Interval (Second to Day, etc.) in Oracle


Himanshu Ahuja

Date and Timestamps both have time added and interval is used in case of manipulation of dates via addition yearwise, datewise etc.

Still unsure about the exact actual difference though when it comes to dates in oracle especially.

Is there any major difference in terms of efficiency or some other difference on the usage of date, timestamp and interval?

Continue reading...