Webscalability

Unix, Systems and Web

Menu

Skip to content
  • Contact me
  • TLS / HTTPS Troubleshooting Tools

Archive of posts tagged date

Datetime arithmetic in sqlite

Posted by james on 19 November 2021, 9:36 am

To find out the # of minutes since a datetime in a sqlite table (example column jobend), do the below: select jobend, cast(((julianday(current_timestamp)-julianday(jobend))*1440) as int) as mins_passed from job Credits

Filed under Uncategorized | Tagged date, sql, sqlite, timestamp | Comment

About me

View James Powell's profile on LinkedIn

profile for jamespo on Stack Exchange, a network of free, community-driven Q&A sites

Recent Posts

  • Fix foot terminal & ssh
  • Gnome Tiling Extension
  • Apache RewriteRule Mitigation for log4shell
  • ~/.config/flake8 not picked up by elpy
  • Datetime arithmetic in sqlite

Pages

  • Contact me
  • TLS / HTTPS Troubleshooting Tools

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2023 Webscalability
Powered by WordPress | Theme F2.