Symptom
In Data Source > Post extraction > Table preview, the date and time has the format YYYY-MM-DD HH:MM:SS.000.
For example;
- 2022-10-26
- 08:15:05.000
However in Post Extraction > (under) Process Data Pipeline > Script preview, the date and time format is different.
For example;
- date: 1666742400000
- time: 29705000
Why is there a difference?
Resolution
The date and time in the Table preview are the result of column formatting.
In the Script preview, the format is Epoch date and time, because it's the raw data (i.e. no formatting).
Keywords
process, intelligence, difference, different, table, preview, script, date, time, format , KBA , BPI-SIG-PI-DI , Data Import for SAP Signavio Process Intelligence , Problem