Why does MariaDb use these terms differently?
#drop table dbstructA;
create table dbstructA(datum date);
insert into dbstructA values('2025-01-01');
insert into dbstructA values('2025-01-02');
insert into dbstructA values('2025-01-03');
insert into dbstructA values('2025-01-04');
insert into dbstructA values('2025-01-05');
insert into dbstructA values('2025-01-06');
insert into dbstructA values('2025-01-07');
select date_format(datum,'%a') as day,
dayofweek(datum) as daynum,
weekday(datum) as numday
from dbstructA where datum>='2025-01-01';
Asked by MBE
(91 rep)
Jul 4, 2025, 07:42 PM
Last activity: Jul 5, 2025, 07:52 AM
Last activity: Jul 5, 2025, 07:52 AM