MySQL :: MySQL 8.0 Reference Manual :: 14.7 Date and Time Functions

Functions That Test Spatial Relations Between Geometry Objects

[somemo]

SELECT SUBDATE(d, WEEKDAY(d)) , WEEKDAY(d) , d from ( select date('2022-12-21') as d union all select date('2022-12-19') as d ) as t 2022-12-19 2 2022-12-21 2022-12-19 0 2022-12-19