KaveriTech Technical Blog

I know this does not take the difference in days – however in a recent project it was helpful for us. Putting it out there if someone can use it.

SELECT PERIOD_DIFF(DATE_FORMAT(DATE(”2008-08-15″), “%Y%m”), DATE_FORMAT(DATE(”2008-01-31″), “%Y%m”));