СREATE TABLE  /*!32300 IF NOT EXISTS*/  info_employe (
  employe_id int( 3 ) unsigned NOT NULL auto_increment,
  employe_date date NOT NULL DEFAULT '0000-00-00' ,
  employe_lname varchar( 32 ) NOT NULL DEFAULT '' ,
  employe_fname varchar( 32 ) NOT NULL DEFAULT '' ,
  employe_mname varchar( 32 ) NOT NULL DEFAULT '' ,
  employe_division varchar( 32 ) , //отдел
  employe_is_dismissed tinyint( 3 ) unsigned ,  /* флаг уволен или нет */ 
  employe_is_retiree tinyint( 3 ) unsigned ,      /* флаг пенсионер или нет */ 
  PRIMARY KEY (employe_id),
  INDEX id_employe_2 (employe_id)
);



#
# Dumping data for table 'info_employe'
#
INSERT INTO info_employe VALUES( "1 ", "1953 - 05 - 26 ", "Иванова" , "Лида" , "Иосифовна" , "БТЗ" , "0 ", "1 ");
INSERT INTO info_employe VALUES( "5 ", "1961 - 10 - 24 ", "Быбина" , "Светлана" , "Петровна" , "Бухгалтерия" , "0 ", "0 ");

SELECT * from info_employe where
MONTH(employe_date)= 2  and (DAYNAME(employe_date)= 1 );

SELECT * from info_employe where
(MONTH(employe_date)= 1  and (DAYNAME(employe_date)= 30 ))
OR
(MONTH(employe_date)= 1  and (DAYNAME(employe_date)= 31 ))
OR
(MONTH(employe_date)= 2  and (DAYNAME(employe_date)= 1 ))
OR
(MONTH(employe_date)= 2  and (DAYNAME(employe_date)= 2 ))
OR
(MONTH(employe_date)= 2  and (DAYNAME(employe_date)= 3 ));

SELECT .... WHERE
employe_date BETWEEN DATE_SUB(NOW(), INTERVAL  1  DAY)
AND
DATE_ADD(NOW(), INTERVAL  1  DAY)
ORDER BY employe_date

SELECT * FROM info_employe
WHERE
employe_date >= DATE_ADD(CURDATE(), INTERVAL - 2  DAY)
AND
employe_date <= DATE_ADD(CURDATE(), INTERVAL  2  DAY)
ORDER BY DATE_FORMAT(employe_date, '%j')

SELECT * FROM info_employe
WHERE
employe_date >= (CURDATE() - INTERVAL  4  DAY)
AND
employe_date <= (CURDATE() + INTERVAL  4  DAY)
ORDER BY DATE_FORMAT(employe_date, '%j')