Convert Date/Time representation in the changelog table

Last updated 3 months ago

Learn how to convert the timestamp in a human readable format.

LightbulbWhat you'll learn

  • Convert timestamp

Person reading a bookPrerequisites

  • Having a CoreMedia system

WristwatchTime matters

Reading time: 1 minute

Person in front of a laptopShould 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

$java -jar LowHighConverter.jar 343 1372153642

Sep 22, 2016 2:05:36 PM
Copyright © 2025 CoreMedia GmbH, CoreMedia Corporation. All Rights Reserved.
Loading...