Search code examples
mysqlsqlstored-proceduresdayofweek

display day through stored procedure

I have an problem in MySQL stored procedure

table tbl_teachers:

id           dat_teacher_doj   fk_int_dept_id

1            1982-01-10          1
2            1979-09-01          1
3            1981-10-13          1

here i need to create an stored procedure to find out the joining date of teachers and if it is a Monday it should display Monday else it should display “Weekday” ? i need the answer like:

call check-date (1982-01-10) ->day weekday

Solution

  • just CASE expression with the help of DAYNAME

    SELECT id, dat_teacher_doj,
       CASE DAYNAME(dat_teacher_doj) WHEN 'Monday' THEN 'Monday' ELSE 'Weekday' END
FROM   tbl_teachers

    Procedure:this will work in localhost phpmyadmin as well as workbench

    CREATE PROCEDURE `GetWeekDay`(IN `paramDate` DATE)
 NO SQL 
SELECT CASE DAYNAME(paramDate) WHEN 'Monday' THEN 'Monday' ELSE 'Weekday' END AS 'WkDy'

    Call

    CALL `GetWeekDay`('2015-08-03');