MySQL DAYOFWEEK - my week begins with monday

Question

I m using DAYOFWEEK   function in MySQL which returns 1 for sunday  But in my country the week starts with monday  not sunday  Is there any chance to get dayofweek from MySQL formated like   1 - Monday  2 - Tuesday

User · Answer

How about subtracting one and changing Sunday  IF DAYOFWEEK     1  7  DAYOFWEEK   - 1    Of course you would have to do this for every query

User · Answer

You can easily use the MODE argument   MySQL      MySQL 5 5 Reference Manual    12 7 Date and Time Functions  If the mode argument is omitted  the value of the default week format system variable is used   MySQL      MySQL 5 1 Reference Manual    5 1 4 Server System Variables

User · Answer

Could write a udf and take a value to tell it which day of the week should be 1 would look like this  drawing on answer from John to use MOD instead of CASE    DROP FUNCTION IF EXISTS  reporting   udfDayOfWeek   DELIMITER   CREATE FUNCTION  reporting   udfDayOfWeek       date DATETIME     firstDay TINYINT   RETURNS tinyint 4  FUNCTION BLOCK  BEGIN   DECLARE  dayOfWeek   offset TINYINT    SET  offset   8 -  firstDay    SET  dayOfWeek    DAYOFWEEK  date     offset  MOD 7    IF  dayOfWeek   0 THEN     SET  dayOfWeek   7    END IF    RETURN  dayOfWeek  END FUNCTION BLOCK   To call this function to give you the current day of week value when your week starts on a Tuesday for instance  you d call   SELECT udfDayOfWeek NOW    3     Nice thing about having it as a udf is you could also call it on a result set field like this   SELECT   udfDayOfWeek p SignupDate  3  AS SignupDayOfWeek    p FirstName    p LastName FROM Profile p

User · Answer

Try to use the WEEKDAY   function      Returns the weekday index for date  0   Monday  1   Tuesday      6     Sunday

User · Answer

Use WEEKDAY   instead of DAYOFWEEK    it begins on Monday   If you need to start at index 1  use or WEEKDAY     1

[mysql] MySQL DAYOFWEEK() - my week begins with monday

Examples related to mysql