$java -jar LowHighConverter.jar 343 1372153642
Sep 22, 2016 2:05:36 PM
Convert Date/Time representation in the changelog table
Last updated 3 months ago
Learn how to convert the timestamp in a human readable format.
What you'll learn
- Convert timestamp
Prerequisites
- Having a CoreMedia system
Time matters
Reading time: 1 minute
Should I read this?
This guide is for Developers, Administrators.
As you might know, CoreMedia stores each single event like the publication or a renaming of an item into a table called "changelog". This table does not only save the information which items have been changed, but especially when the event took place. To receive a unique timestamp for each event, it is represented as milliseconds since 1.1.1970. As this number is "pretty" high (at the moment approx. 1,5 trillions) it is split into two separate fields called "timehigh" and "timelow".
If you as a CoreMedia Admin now need to convert these two values into a human readable date, this JAR file does the job for you.
Example
Is this page useful?