Jump to content
Introducing Home, launching on Mac, Windows, and Evernote Web (English, Español, & 日本語) ×
UPDATE: Evernote for Mac and Windows 10.6 is here ×
Update: Email a Copy of a Note ×
Update: Evernote 10.4 for Android and iOS ×
Forum Digest: January '20 ×

Search the Community

Showing results for tags 'unix epoch'.

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type


Calendars

There are no results to display.

There are no results to display.

Forums

  • General Discussion
    • Community Announcements
    • Evernote General Discussions
    • Evernote Integrations
    • Evernote API Discussion
    • FAQ's: Best Answers
  • Early Access Program
    • Public Betas
  • Evernote Business
    • Evernote Business Technical Issues
    • Evernote Business Requests
  • Possible Bugs/Technical Issues
    • Evernote for Android Issues (Versions 8.13.3 and under)
    • Evernote for iOS Issues (Versions 10.0 and above)
    • Evernote for iOS Issues (Versions 8.24.6 and under)
    • Evernote for Mac Issues (Versions 10.0 and above)
    • Evernote for Mac Issues (Versions 7.14 and under)
    • Evernote for Windows Issues (Versions 10.0 and above)
    • Evernote for Windows Issues (Versions 6.25.1 and under)
    • General Technical Issues
    • Web Client Issues
    • ScanSnap Home Support
    • Evernote Product Suite Issues
  • Product Feedback/Feature Requests
    • Evernote for Android Requests (Versions 10.0 and above)
    • Evernote for Android Requests (Versions 8.13.3 and under)
    • Evernote for iOS Requests (Versions 10.0 and above)
    • Evernote for iOS Requests (Versions 8.24.6 and under)
    • Evernote for Mac Requests (Versions 10.0 and above)
    • Evernote for Mac Requests (Versions 7.14 and under)
    • Evernote for Windows Requests (Versions 10.0 and above)
    • Evernote for Windows Requests (Versions 6.25.1 and under)
    • General Feature Requests
    • Evernote Web Client Requests
    • Evernote Product Suite Requests
  • Foro de discusión de Evernote
    • Anuncios Comunitarios
    • Discusión General
    • Posibles Defectos/Problemas Técnicos
    • Solicitud de Funciones
  • International Forums
    • Japanese Discussions
    • Brazilian Portuguese Discussions
    • Korean Discussions
    • Traditional Chinese Discussions
  • Evernote Forum Archives
    • General Discussion/Requests/Issues Archive
    • FAQ's: Best Answers
    • Evernote Business Archive
    • Android Archive
    • iOS Archive
    • Mac Archives
    • Windows Archive
    • Web Client Archives
    • Penultimate Archives
    • Skitch (iOS) Archives
    • Skitch (Mac) Archives
    • Web Clipper Archives

Blogs

  • Evernote Forum Digest
  • Evernote Forum User Council's User Council Handbook

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 1 result

  1. Cuchulain of Muirthemne
    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-
×
×
  • Create New...