Sample Header Ad - 728x90

Dayofweek vs weekday

-2 votes
2 answers
87 views
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