Announcement

Collapse
No announcement yet.

HowTo explain db-entries for 'date'

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • HowTo explain db-entries for 'date'

    Hello,

    for analyzing purposes I want to retrace some DB-entries. My problem is es explanation of date-formats. For example, in the table 'prg_contacts' I've found the value

    '1263938752928' for 'creating_date'

    and

    '1263938752928' for 'changing_date'

    To witch real date conform these values to? How can I convert the db-dates?
    Viele Gre
    Rene

    OS: Ubuntu Server amd64 16.4 LTS
    JRE: openjdk-8-jre, MySQL 5.7, Apache 2.4, Dovecot 2.2.22
    OX-Server backend: OXSE latest
    OX-frontend: OXSE latest appsuite + ox6

  • #2
    Hi Rene,

    those are 64bit signed Long values of UNIX Timestamps that we use through the whole groupware. You can cut off the last 3 digits and calculate the "real" time based on the unix timestamp.
    Code:
    mbraun@mbraun:~$ date -ud @1263938752
    Tue Jan 19 22:05:52 UTC 2010
    Greetings

    Comment

    Working...
    X