Support Article
Milliseconds in TimeStamp not retrieved using report definition
SA-45078
Summary
Milliseconds inserted by TimeStamp truncates when retrieving them using a report definition. This occurs when the pxTimeCreated and pxSaveDateTime properties are saved to a database.
Error Messages
Not Applicable
Steps to Reproduce
- Create a report definition with pxTimeCreated and pxSaveDateTime properties.
- Create a data page and source it with the report definition.
- Run the data page.
Root Cause
A software use or operation error.
In the pc_history_work table, pxTimeCreated column data type is Date.
Resolution
Perform the following local-change:
- Modify the data type to Timestamp in the database for pxTimeCreated column in the pc_history_work table.
- Save the Admin-DB-Table instance for the pc_history_work table.
Published April 13, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.