AdrianLobacz
Databricks Partner

Some hints for you

TIMESTAMP supports fractional seconds, unlike DATE which supports only seconds

TIMESTAMP exist in three flavors:

TIMESTAMP does not contain any time zone information.

TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE contain time zone information

Regarding calculation and manipulation there is actually no difference between TIMESTAMP and DATE. There are only a very few functions which support only either of these two types.

DATE is an old data type. TIMESTAMP was introduced later (well "later" means in 9i, i.e. 20 years ago) INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are interval data types, they do not contain any absolute date information.

Hope this gave some hints.