Dates from various centuries

PHP
1

So I have a project that deals with creating timelines, etc using dates from various centuries. I can store those in the MySQL database just fine but can’t do any comparing between todays date and the historical dates (such as days since certain events occured). Anyone have any idea on if it’s possible to get the number of days between two dates when one is hundreds of years ago?

(so obviously “strtotime” won’t work)

2

What is the exact format of the dates in your database? Can you show an example of one?

3

just in regular ‘date’ format: ‘1500-05-22’

4

run this and see what you get –


SELECT DATEDIFF(CURRENT_DATE,'1500-05-22') AS diff
5

Duh…got it. I kept thinking of doing it with php instead of MySQL. Perfect. Thanks.

6

Great, this is one page you should study http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html