SQL query - monday as start of the week in calendar

[bartek24m]

Hi i looking for some query which an able me to set monday as dey of start week for all users and guest

Thank you for help

[bartek24m]

anyone ?

[Adrian Schneider]

<a href="https://vborg.vbsupport.ru/showthread.php?t=109731" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=109731</a>

HTH

[bartek24m]

but its only for new registration i would like to set all my registred users i know that it can be done by MYSQL query like

UPDATE TABLE 'users' where 'startweek' = 1;


or sth like that

[kh99]

Well, the table is called prefix_user (where prefix_ is whatever your prefix is set to), the field is called startofweek, and the value for Monday seems to be 2. So in theory it should be:

UPDATE prefix_user SET startofweek = 2


but I'm not sure and I haven't tried it, it could trash your site for all I know. :)

[bartek24m]

if someone can confirm this query ?
it's will be work ?

[Adrian Schneider]

Yes but it won't affect new registrations.