between 2 dates select latest_date, lowest_date, floor(datediff(date(latest_date), date(lowest_date)) / 365) from your_table

Converts something like 45353 into 2012-11-10 update as tb set tb.your_mysql_datefield = date_add(date('1899-12...

Best results in other decks

Passei pela seguinte experiência. Mockei (usando Gmock) o construtor default de Date, e então começou a dar um erro no...

Search in all decks