Unix Time 1794000000 will occur on Friday, November 6th at 21:20:00 UTC+0000

https://youtu.be/srhwc7cvaRo

#1794000000 #UNIXTIME #unixepoch #y2k38 #y2k36

Learn what a Unix timestamp is and how to convert it in Linux, Python, JavaScript, and SQL.

Full Guide Here: ostechnix.com/unix-timesta...

#UnixTimestamp #Unixepoch #POSIX #UTC #Linux #Linuxbasics #Linuxadmin #Python #Javascript #SQL

you should be able to do:

create table something (timestamp int default (unixepoch()));

unixepoch()

Have you ever gotten a date back from an API or other source, expecting a readable date, but gotten an integer such as 1747927975516? Chances are it's a Unix timestamp in milliseconds. You can convert it to a human-readable format with this #PowerShell one-liner (code in alt text).

Waiting for similar headlines for the Year 2038 problem!

#Year2038 #UnixEpoch #Signed32bit

タブノートのエクスポート例

$ cp $FIREFOXPROFILEDIR/tabnotes.sqlite /tmp/
$ sqlite3 -readonly -header -csv /tmp/tabnotes.sqlite "SELECT id, canonical_url, note_text, datetime(created,'unixepoch','localtime') AS created FROM tabnotes ORDER BY created DESC;"
id,canonical_url,note_text,created
4 […]

Firefox はこんな感じ

$ cp -p ~/.mozilla/firefox/4q5mj0jg.default-release-2/places.sqlite /tmp/
$ sqlite3 /tmp/places.sqlite -header -csv "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch') AS visit_time, moz_places.url, moz_places.title, moz_places.description FROM moz_places JOIN moz_ […]

You have 1824 ratings in the last 30 days (includes likes, posts and reposts)

sqlite> select count(*) from ratings where rater_id = (select id from raters where uid = 'did:plc:565ebob5f6hw33hjdkxty6qj') and created_timestamp > unixepoch('subsec') - 60*60*24*30;
1824