TIMESTAMP Data Type

The TIMESTAMP data type is an extension of the DATE data type.

microsoft sharepoint certification training courses malaysia

TIMESTAMP stores fractional seconds in addition to the information stored in the DATE data type. The TIMESTAMP data type is useful for storing precise time values, such as in applications that must track event order.

sap wm warehouse management training courses malaysia

The DATETIME data types TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE are time-zone aware. When a user selects the data, the value is adjusted to the time zone of the user session. This data type is useful for collecting and evaluating date information across geographic regions.

sap supply chain management scm training courses malaysia

See also

Oracle Database SQL Language Reference for details about the syntax of creating and entering data in time stamp columns

sap s 4 hana training courses malaysia

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *