Homepage | Products | OX Knowledge Base | Support | Try Now | Contact | Company
OX Logo
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    107

    Default 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 12.4 LTS
    JRE: openjdk-7-jre, MySQL: 5.5, Apache 2.2, Dovecot 2.0.19
    OX-Server backend: OXSE latest
    OX-frontend: OXSE latest appsuite + ox6

  2. #2
    Join Date
    Feb 2007
    Location
    Germany
    Posts
    3,695

    Default

    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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •