Discussion Board

Results 1 to 4 of 4
  1. #1
    Registered User
    Join Date
    Jun 2013

    Question Symbian 9.4 S60 date Format

    Hi! I have to parse the "metadata.sq" file out side the phone (means i am not working on a phone app). In this metadata.sq file there is table named as eventlog. This table has a column Timestamp which holds datetime stamp of the logged event. I guess this datetime is a Tint64 number. Could anybody please suggest me a way to convert this tint 64, 17 digit datetime stamp into calendar and time? An example entry of time stamp is like this: 63485993605262000.

  2. #2
    Nokia Developer Champion
    Join Date
    Mar 2013

    Re: Symbian 9.4 S60 date Format

    I dont know that specific file or that specific table but your timestamp sounds like a standard epoch time to me ( int64 )
    if you want to know how to convert it to a human readable format checkout http://www.epochconverter.com/ and look at the bottom "Convert from epoch to human readable date" it has codes for almost any language.

  3. #3
    Registered User
    Join Date
    Jun 2013

    Re: Symbian 9.4 S60 date Format

    the problem here is that the epoch ticks are suppose to be an 18 digit number but in my file all timestamps are 17 digit number.

  4. #4
    Nokia Developer Moderator
    Join Date
    Feb 2006
    Oslo, Norway

    Re: Symbian 9.4 S60 date Format

    I wonder why you think that. According to the linked page current epoch time is 1371458991, which is a 10-digit number. And you can freely copy-paste your 63... number there, to find out it is 2171, March something.
    Just Symbian times are not epoch times, that is why the date is strange. Instead they are the number of microseconds counted from the 1st of January, 1 (AD), 00:00:00.
    Conversion to epoch-base: subtract 62168256000000000 and divide by a million.
    Like 63485993605262000-62168256000000000=1317737605262000, 1317737605 without the last 6 digits. And copying it to the page linked by Shai.i it becomes "GMT: Tue, 04 Oct 2011 14:13:25 GMT", which is a believable date.

Similar Threads

  1. Date Format
    By enovate_symbianteam in forum Symbian C++
    Replies: 1
    Last Post: 2010-08-24, 11:19
  2. Date Format
    By rasmi in forum Mobile Java General
    Replies: 4
    Last Post: 2009-11-13, 06:01
  3. date format
    By waseemahmad in forum Symbian C++
    Replies: 2
    Last Post: 2008-08-19, 16:09
  4. Date format...!!!
    By palak_shah_23 in forum Symbian C++
    Replies: 4
    Last Post: 2006-09-07, 07:27
  5. Date format
    By ksmar in forum Browsing and Mark-ups
    Replies: 0
    Last Post: 2006-02-14, 12:35

Posting Permissions

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