MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.4.34-MariaDB-1:10.4.34+maria~deb10-log


-- application-time periods arrived in MariaDB 10.4
create table booking (room int, s date, e date, period for stay (s,e));
insert into booking values (1,'2026-01-01','2026-12-31');
-- delete part of the period and the row splits in two
delete from booking for portion of stay from '2026-06-01' to '2026-07-01';
select * from booking order by s;


room
s
e


1
2026-01-01
2026-06-01

1
2026-07-01
2026-12-31