MySql difference between two timestamps in days?

by

If you’re happy to ignore the time portion in the columns, DATEDIFF() will give you the difference you’re looking for in days.

SELECT DATEDIFF('2010-10-08 18:23:13', '2010-09-21 21:40:36') AS days;
+------+
| days |
+------+
|   17 |
+------+

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. MySQL convert date string to Unix timestamp
  3. Timestamp with a millisecond precision: How to save them in MySQL
  4. Group mysql query by 15 min intervals
  5. MySQL Query GROUP BY day / month / year
  6. Error in MySQL when setting default value for DATE or DATETIME
  7. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  8. MySQL Query to select data from last week?
  9. How to get the difference between two timestamps in seconds
  10. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  11. How to select date from datetime column?
  12. How to convert number of week into date?
  13. Set NOW() as Default Value for datetime datatype?
  14. SQL Query to show nearest date?
  15. How to subtract hours from a datetime in MySQL?
  16. How to convert time to the time zone of the iPhone device?
  17. Select data between a date/time range
  18. mysql: get record count between two date-time
  19. How to cast DATETIME as a DATE in mysql?
  20. How to get current date & time in MySQL?
  21. how to cast the hexadecimal to varchar(datetime)?
  22. MySQL CURRENT_TIMESTAMP on create and on update
  23. Use MySQL to determine whether today is a user’s birthday
  24. When is a timestamp (auto) updated?
  25. Using MySQL’s TIMESTAMP vs storing timestamps directly
  26. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  27. how to partition a table by datetime column?
  28. How do I alter a mysql table column defaults?
  29. MySQL: Insert datetime into other datetime field
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment