Unix timestamp in sqlite?
select strftime('%W'),date('now'),date(),datetime(),strftime('%s', 'now');
result in
strftime('%W') - date('now') - date() - datetime() - strftime('%s', 'now') 08 - 2021-02-23 - 2021-02-23 - 2021-02-23 15:35:12- 1614094512
For some reason (that's undoubtedly my fault) Daniel's julianday()
component doesn't quite do it for me, but resorting to the following jankery appears to do the trick when selecting from a timestamp field called tmstmp:
select strftime('%s', a.tmstmp) + strftime('%f', a.tmstmp) as unix_timefrom any_table a