MySQL:

TO_DAYS

Syntax:
TO_DAYS(date)

Given a date date, returns a day number (the number of days since year
0).

URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

mysql> SELECT TO_DAYS(950501);
-> 728779
mysql> SELECT TO_DAYS('2007-10-07');
-> 733321

bottom of page