SAP Date & Timestamp Converter
SAP ABAP stores dates as DATS (`YYYYMMDD` char(8)) and times as TIMS (`HHMMSS` char(6)), plus UTC timestamps as packed decimals (seconds since 1970 or with 7 fractional digits). Converting between ABAP fields and Unix/ISO is a daily task in SAP integrations.
This converter renders your date-time as ABAP DATS, ABAP TIMS, and the SAP UTC timestamp (both integer and with fractional part) for BAPI/IDoc payloads.
SAP Date & Timestamp Converter Quick Reference
| Format | Pattern / Description | Example 1 | Example 2 |
|---|---|---|---|
| SAP BAPI Date | YYYYMMDD | 20260813 | 20260101 |
| SAP BAPI Timestamp | YYYYMMDDHHMMSS | 20260813143000 | 20260101000000 |
* Examples are rendered in UTC for the fixed sample instants above.
When to Use SAP Date & Timestamp
SAP interface development
Build BAPI/IDoc date fields in DATS/TIMS format without format-mask mistakes.
ABAP-to-middleware mapping
Convert SAP UTC timestamps to ISO 8601 for REST/ODATA endpoints and vice versa.
Data migration to S/4HANA
Normalize legacy date fields into S/4HANA TIMESTAMP columns correctly.
Frequently Asked Questions
What is the SAP DATS format?
A char(8) field `YYYYMMDD` (e.g. `20260813`), the default ABAP date type. It is a string, not a numeric.
What is the SAP TIMS format?
A char(6) field `HHMMSS` (e.g. `143000`) for ABAP time-of-day values.
What is the SAP UTC timestamp?
A packed decimal of seconds since 1970-01-01 UTC (14 digits) or `TIMESTAMP(9)` with nanoseconds in S/4HANA HANA columns.
How does SAP handle timezones?
ABAP `sy-datlo`/`sy-timlo` are local; `GET TIME STAMP` returns UTC. Conversions use `CONVERT TIME STAMP` with a timezone table.
Related Time Format Converters
All Format Guides
Need to Convert Between All Formats?
Use the main Time Format Converter for instant conversion across 100+ formats — epoch, ISO 8601, RFC 3339, SQL datetime, military time and more in one click.
Open Time Format Converter