Search the Community
Showing results for tags 'timestamp'.
It would be great if you could include a button in the Android App, to enter a current timestamp, wherever the blinking cursor is in the note. A simple tap of a button, will allow users to insert a timestamp anywhere within the note. If the note is being continued from an earlier date, then adding a timestamp to the current position of the blinking cursor, will mark that area of the note, with the current time that the note is being updated. Thank you! - Stephen Robinson
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-