In Valuemation, you are likely to come across the following types of date&time data:
- Business Data of Attribute Type Date
The Date attribute type is used for entries which do not require greater than one day precision. Consequently, no time zone offset is applicable here. Use this attribute type for time zone independent entries for which one day precision is sufficient.
- Business Data of Attribute Type Timestamp
The Timestamp attribute type aggregates date and time information into one attribute thus making it possible for a time zone offset to be applied to it. This attribute type should be used for all time zone dependent entries.
- Business Data of Attribute Type Time
The Time attribute type is used for entries containing time information in hours (and fractions of an hour down to the order of nanoseconds) separated from the date information. Hence, this attribute type would be used mainly for time intervals and is time zone independent.
- Internal Data
Technically speaking, all Valuemation objects contain time-related data. The date&time information is created automatically by the application whenever an object is crated or modified and is generally used by the application itself to track changes.
Internal Date&Time data get stored in attributes Datcre (Date&Time of object creation) and Datchn (Date&Time of object change) of Timestamp attribute type. They are not visible in the ObjectType Customizer but may be displayed in Views and Catalogs.
The following table summarizes information on available Date&Time attribute types . Alternative values provided in the "Can Be Used for Column Type" column are due to the dependence on the Database Management System used.