Convert PIT time used in scheduling to real date – Report CYDATTIM
Scheduling internally converts the dates in seconds relative to a reference date (1980.1.1). It is called PIT time. E.g. 1 o’clock on 1980.1.1, 1 hours is 3600 seconds, so this date/time is represented as 3600 internally.
Reference date 1980.1.1 is hard-coded. Only date between 1980.1.1 and 2048.1.1 can be converted without problem. Considering 2048 is approaching, you can use note 49257 to change the reference date.
Sometimes the scheduling result is hard to be explained, you want to analyze it via debugging. However, the dates are a long number in internal calculation. Report CYDATTIM can be used to get the real date/time.
Execute report CYDATTIM in t-code SE38
There are 5 fields.
- DATED – Real date
- TIMED – Real time
- DATEI – Integer format for date
- TIMEI – Integer format for time
- PIT – seconds from reference date
In this sample, PIT equals to 1,123,722,816, what is the real date/time for this PIT? It is 2015.8.11 01:13:36.