TIMESTAMP is an application domain that has the following characteristics:

  • data type in the data base is TIMESTAMP (see below)
  • screen representation is as a text field (usually display only - as the value would be system generated)

TIMESTAMP is an Oracle data type that indicates this field holds a date/time value.

TIMESTAMP is similar to DATE but allows for accuracy down to three decimal places beyond seconds (the most granular that DATE goes).