×

Discussion Board

Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    May 2013
    Posts
    1

    Red face Database Date and Time Conversion

    Hi all,

    We have a database file from a Nokia N8 which has a date column with the following data:-

    63518562987097375

    The field is INT64. Does anyone know how to convert this into a human 'readable' date and time? The date and time and time should display '15/10/2012 14:16:13'

    What format is the origanal data stored in? Is it the number of nanoseconds from a start date?

    I am trying to convert this in microsoft excel. Here are some more examples:-

    63529263215689000 = 16/02/2013 09:34:33
    63529226555177000 = 15/02/2013 23:23:31
    63511711520467625 = 27/07/2012 19:36:29

    Thank you

  2. #2
    Registered User
    Join Date
    Jan 2005
    Location
    Italy
    Posts
    639

    Re: Database Date and Time Conversion

    Hello,
    it could be the TInt64 representation of TTime object:
    http://docs.huihoo.com/symbian/nokia...3B2004821.html
    if you can't sort it out with some magical excel formula, try with a simple Symbian app:
    http://www.developer.nokia.com/Commu...ts_using_TTime
    hope it helps
    br
    pg

Similar Threads

  1. string to date conversion
    By swap_nil in forum Mobile Java Networking & Messaging & Security
    Replies: 1
    Last Post: 2009-07-11, 20:40
  2. Replies: 9
    Last Post: 2009-02-13, 11:57
  3. How to add Date(any date.. to show last updated time) to CustomItem
    By durganprasad in forum Mobile Java General
    Replies: 6
    Last Post: 2008-09-23, 06:54
  4. Replies: 0
    Last Post: 2008-01-03, 17:58
  5. How to search from database by date
    By suppe79 in forum Symbian
    Replies: 1
    Last Post: 2005-07-14, 10:46

Posting Permissions

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