Showing posts with label convert date to number of days mysql. Show all posts
Showing posts with label convert date to number of days mysql. Show all posts

Thursday, 12 July 2012

to_days() function in mysql

SELECT TO_DAYS(950501); output: 728779
SELECT TO_DAYS('2007-10-07'); output: 733321
to_days(date) function will give output to number of days since year 0 of the passing argument date.