Code | SQL

snippets from a software engineer

Currently viewing the tag: "SQL"

Calculating time differences in MySQL

By tpp On December 17, 2013 · Add Comment ·

I need to calculate the average completion time of an operation for something I’m working on at the moment. We’re using MariaDB. The natural way to do this is: [crayon-67ebcef37b0dd132076737/] However, the values of the Time data type in MySQL can only range between ‘-838:59:59’ to ‘838:59:59’. This becomes an issue if you have to [...]

[Continue Reading...]

Recent Posts
Tags
BatchInserter cli underscore Google Apps Google Docs java JavaScript JSON memcached mongodb monitor MySQL neo4j neo4j-spatial redis SOA Spring Data for Neo4j Spring Framework SQL timediff time functions
Posts
- December 2013 (1)
- November 2012 (1)
- September 2012 (2)
- June 2012 (1)
- April 2012 (1)

Code

Pages

The Latest

Calculating time differences in MySQL
I need to calculate the average completion time of an operation for […]

More

© 2012 Code