Jump to content
Issues accessing Evernote Support Channels Read more... ×

Search the Community

Showing results for tags 'sqlite'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General Discussion
    • Community Announcements
    • Spaces for Evernote Business
    • Evernote General Discussions
    • Using Evernote
    • Evernote API Discussion
    • Evernote Integrations
    • Evernote Research Discussion
  • Possible Bugs/Technical Issues
    • Evernote Business
    • Evernote for Android
    • Evernote for iOS
    • Evernote for Mac
    • Evernote for Windows
    • Web Client
    • Evernote Product Suite
    • General Technical Issues
  • Product Feedback/Feature Requests
    • Evernote Business
    • Evernote for Android
    • Evernote for iOS
    • Evernote for Mac
    • Evernote for Windows
    • Evernote Web Client
    • Evernote Product Suite
    • General Feature Requests
  • International Forums
    • Japanese Discussions
    • Brazilian Portuguese Discussions
    • Discussions in Spanish
    • Korean Discussions
    • Traditional Chinese Discussions
  • Evernote Forum Archives
    • General Discussion Archive
    • Product Archives

Categories

There are no results to display.

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Subscription

Found 4 results

  1. Hi folks, I querying the SQLite DB directly and have had some strange encounters with the timestamp fields. From what I can gather they are supposed to be based on the Unix Epoch of 1970-01-01 This timestamp; 736012.8334375 is 2016/02/18 21:00 but trying multiple variants such as select datetime(((((736012.8334375)*1000/60)/60)/24), 'unixepoch'), datetime(((736012.8334375)), 'unixepoch'), datetime(736012.8334375, 'unixepoch'), strftime('%s', 'now'), strftime('7736012.8334375', 'unixepoch'), datetime(736012.8334375, 'unixepoch') Just gives "1970-01-01 02:21:58","1970-01-09 12:26:52","1970-01-09 12:26:52","1464340190",,"1970-01-09 12:26:52" This Excel formula =((((736012.8334375)*1000/60)/60)/24)+DATE(1970,1,1)+(1/24) 4/28/93 5:00 PM Has anyone dealt with this before? Can they shed some light into this hole I'm in Thanks /C
  2. Hi everyone, I would like to know how to export(if possible) all my notes into a SQL DB, so that I can do all sorts of things with the data. What i would like to do, instead of manually inputting all the date. a way to code via vs2013 to input the date via a program that i can make. Thanks
  3. Hi, do any 3rd party apps use the same sqlite database format (schema - tables and indexes) as Evernote? (Specifically the Windows version - don't know if other platforms differ.) In the course of developing our evernote client app we're ending up with a database format that looks very similar, sans a few attributes and indexes. We were wondering if it is OK go ahead and use the same sqlite format as Evernote (at our own risk and testing of course), or is this something you'd consider proprietary? TIA.
  4. I played a bit with Evernote.sql SQLite db file - first in SQLite Manager (plugin for Firefox), then I wrote a simple Ruby on Rails application that reads the db and displays or updates content/pNNN/content.html pages. Any legal issues with this approach? Do I violate your license agreement or something? Thanks
×