Why mysql datetime minus not correct?

This SQL. It is very obvious that the seconds should be 86400 for one day. Why MYSQL return 1000000? select str_to_date(‘2021-04-24 00:00:00’, ‘%Y-%m-%d %H:%i:%s’) – str_to_date(‘2021-04-23 00:00:00’, …

Mixed Date Formats Update

changing all dates to standard date time in dataframe This link helps, but doesn’t quite get me, or more likely I am not making the leap to get there. Currently, mixed dates “2021-04-15”, &…