A little more about TIMESTAMP datatype

TIMESTAMP can be used in any of the following ways:

1. datetimestamp (fractional seconds precision)

fractional seconds precision must be a number between 0 and 9 (default is 6), eaxample, timestamp(6)

2. timestamp (fractional seconds precision) with time zone
Includes year, month, day, hour, minute, and seconds with a time zone displacement value. Example timestamp(9) with time zone

3. timestamp (fractional seconds precision) with local time zone
Here time zone is expressed as the session time zone For example: timestamp(6) with local time zone

4. interval year (year precision) to month
Here, Time period stored in years and months. For example: interval year(6) to month

5. interval day (day precision) to second (fractional seconds precision)
Time period stored in days, hours, minutes, and seconds with a fractional seconds precision. For example: interval day(2) to second(6)