SAP Knowledge Base Article - Public

3272631 - Difference between Process Intelligence Script preview and Table preview 'Date/Time' format

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

Product

SAP Signavio Process Intelligence 3.0