SAP ABAP Data Element DB2TIMESTAMP (DB2-z/OS: General purpose timestamp in DB2 hex format)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | DB2TIMESTAMP |
| Short Description | DB2-z/OS: General purpose timestamp in DB2 hex format |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | NUMC | Character string with only digits |
| Length | 20 | |
| Decimal Places | 0 | |
| Output Length | 20 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 4 | Time |
| Medium | 13 | DB2 Timestamp |
| Long | 39 | General purpose timestamp in DB2 format |
| Heading | 49 | DB2-z/OS: General purpose timestamp in DB2 format |
Documentation
Definition
General purpose timestamp which is unformatted (only digits):
YYYYMMDDhhmmssffffff
Where
YYYY is 4 digit year
MM is two digit month
DD is two digit day
hh is two digit hour in 24 hour format
mm is two digit minutes
ss is two digit seconds
ffffff is 6 digit microseconds
Use
As this data element is of general purpose, you can use it for any DB2 timestamp, that is retrieved with formatting hex(...).
Dependencies
Example
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
