Google Calendar RSS --> Calendar.sqlitedb

Discussion in 'iOS Jailbreak & Cydia' started by idkfk, Nov 4, 2007.

  1. idkfk

    idkfk New Member

    Joined:
    Oct 29, 2007
    Messages:
    1
    Likes Received:
    0
    Has anyone attempted to write a small app that would chew on a Google Calendar RSS feed and import that data into the Calendar sqlite database for re-upload back onto the iphone/ipod file system?

    The dateformat in the mobile cal sqlitedb file is a little strange though. Anyone know how to decipher this format?

    217620000 = Nov 24 2007 @ 10AM
    217623600 = Nov 24 2007 @ 11AM
  2. cogita

    cogita New Member

    Joined:
    Mar 30, 2008
    Messages:
    6
    Likes Received:
    0
    Device:
    iPod touch
    the 3600 indicates that this format is based of the Unix Timestamp format. This format counts the number of seconds since an arbitrary date (January 1st 1970, 0:00:00) 3600 is the number of seconds in a hour. Instead of starting at Jan 1st 1970, ipod Touch calendar file starts at 'Jan 1st 2001 0:00:00'

Share This Page