How can I make an average of dates in MySQL?

by

This seems a bit hackish, but will work for dates beteen ~ 1970 and 2030 (on 32 bit arch). You are essentially converting the datetime values to integer, averaging them, and converting the average back to a datetime value.

SELECT
    from_unixtime(
        avg(
            unix_timestamp(date_one)-unix_timestamp(date_two)
        )
    )
FROM
    some_table
WHERE
    some-restriction-applies

There is likely a better solution out there, but this will get you by in a pinch.

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. PostgreSQL GROUP BY different from MySQL?
  5. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  6. Fulltext Search with InnoDB
  7. MySQL dump by query
  8. MySQL’s now() +1 day
  9. Delete sql rows where IDs do not have a match from another table
  10. Rewriting mysql select to reduce time and writing tmp to disk
  11. How do I convert from BLOB to TEXT in MySQL?
  12. Can you access the auto increment value in MySQL within one statement?
  13. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  14. Which SQL query is better, MATCH AGAINST or LIKE?
  15. What does DELIMITER // do in a Trigger?
  16. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  17. MySQL equivalent of DECODE function in Oracle
  18. How do you version your database schema? [closed]
  19. MySQL, Get users rank
  20. Mysql: how to select groups having certain values?
  21. How to create a multi-tenant database with shared table structures?
  22. MySQL #1140 – Mixing of GROUP columns
  23. MySQL: GROUP_CONCAT with LEFT JOIN
  24. Boolean vs tinyint(1) for boolean values in MySQL
  25. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  26. Find rows that have the same value on a column in MySQL
  27. what is the difference between GROUP BY and ORDER BY in sql
  28. How to transform vertical data into horizontal data with SQL?
  29. I want to copy table contained from one database and insert onto another database table
  30. How do MySQL views work?

Leave a Comment