My SQL dump file to create table with records for testing queries with day month and time range.

These SQLs are created considering today's date as base. So you can take a fresh copy from here ( every day ) and use the same to test your query.
Use the below query to create table in MysQL workbench or PHPMyAdmin and add records for duration ( + and - )370 days from today.

CREATE TABLE IF NOT EXISTS `dt_table` (
  `record_id` varchar(4) NOT NULL,
  `date` date NOT NULL,
  `month-year` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `dt_table` VALUES ('-370', '2025-12-16','Dec-2025' ),
('-369', '2025-12-15','Dec-2025' ),
('-368', '2025-12-14','Dec-2025' ),
('-367', '2025-12-13','Dec-2025' ),
('-366', '2025-12-12','Dec-2025' ),
('-365', '2025-12-11','Dec-2025' ),
('-364', '2025-12-10','Dec-2025' ),
('-363', '2025-12-09','Dec-2025' ),
('-362', '2025-12-08','Dec-2025' ),
('-361', '2025-12-07','Dec-2025' ),
('-360', '2025-12-06','Dec-2025' ),
('-359', '2025-12-05','Dec-2025' ),
('-358', '2025-12-04','Dec-2025' ),
('-357', '2025-12-03','Dec-2025' ),
('-356', '2025-12-02','Dec-2025' ),
('-355', '2025-12-01','Dec-2025' ),
('-354', '2025-11-30','Nov-2025' ),
('-353', '2025-11-29','Nov-2025' ),
('-352', '2025-11-28','Nov-2025' ),
('-351', '2025-11-27','Nov-2025' ),
('-350', '2025-11-26','Nov-2025' ),
('-349', '2025-11-25','Nov-2025' ),
('-348', '2025-11-24','Nov-2025' ),
('-347', '2025-11-23','Nov-2025' ),
('-346', '2025-11-22','Nov-2025' ),
('-345', '2025-11-21','Nov-2025' ),
('-344', '2025-11-20','Nov-2025' ),
('-343', '2025-11-19','Nov-2025' ),
('-342', '2025-11-18','Nov-2025' ),
('-341', '2025-11-17','Nov-2025' ),
('-340', '2025-11-16','Nov-2025' ),
('-339', '2025-11-15','Nov-2025' ),
('-338', '2025-11-14','Nov-2025' ),
('-337', '2025-11-13','Nov-2025' ),
('-336', '2025-11-12','Nov-2025' ),
('-335', '2025-11-11','Nov-2025' ),
('-334', '2025-11-10','Nov-2025' ),
('-333', '2025-11-09','Nov-2025' ),
('-332', '2025-11-08','Nov-2025' ),
('-331', '2025-11-07','Nov-2025' ),
('-330', '2025-11-06','Nov-2025' ),
('-329', '2025-11-05','Nov-2025' ),
('-328', '2025-11-04','Nov-2025' ),
('-327', '2025-11-03','Nov-2025' ),
('-326', '2025-11-02','Nov-2025' ),
('-325', '2025-11-01','Nov-2025' ),
('-324', '2025-10-31','Oct-2025' ),
('-323', '2025-10-30','Oct-2025' ),
('-322', '2025-10-29','Oct-2025' ),
('-321', '2025-10-28','Oct-2025' ),
('-320', '2025-10-27','Oct-2025' ),
('-319', '2025-10-26','Oct-2025' ),
('-318', '2025-10-25','Oct-2025' ),
('-317', '2025-10-24','Oct-2025' ),
('-316', '2025-10-23','Oct-2025' ),
('-315', '2025-10-22','Oct-2025' ),
('-314', '2025-10-21','Oct-2025' ),
('-313', '2025-10-20','Oct-2025' ),
('-312', '2025-10-19','Oct-2025' ),
('-311', '2025-10-18','Oct-2025' ),
('-310', '2025-10-17','Oct-2025' ),
('-309', '2025-10-16','Oct-2025' ),
('-308', '2025-10-15','Oct-2025' ),
('-307', '2025-10-14','Oct-2025' ),
('-306', '2025-10-13','Oct-2025' ),
('-305', '2025-10-12','Oct-2025' ),
('-304', '2025-10-11','Oct-2025' ),
('-303', '2025-10-10','Oct-2025' ),
('-302', '2025-10-09','Oct-2025' ),
('-301', '2025-10-08','Oct-2025' ),
('-300', '2025-10-07','Oct-2025' ),
('-299', '2025-10-06','Oct-2025' ),
('-298', '2025-10-05','Oct-2025' ),
('-297', '2025-10-04','Oct-2025' ),
('-296', '2025-10-03','Oct-2025' ),
('-295', '2025-10-02','Oct-2025' ),
('-294', '2025-10-01','Oct-2025' ),
('-293', '2025-09-30','Sep-2025' ),
('-292', '2025-09-29','Sep-2025' ),
('-291', '2025-09-28','Sep-2025' ),
('-290', '2025-09-27','Sep-2025' ),
('-289', '2025-09-26','Sep-2025' ),
('-288', '2025-09-25','Sep-2025' ),
('-287', '2025-09-24','Sep-2025' ),
('-286', '2025-09-23','Sep-2025' ),
('-285', '2025-09-22','Sep-2025' ),
('-284', '2025-09-21','Sep-2025' ),
('-283', '2025-09-20','Sep-2025' ),
('-282', '2025-09-19','Sep-2025' ),
('-281', '2025-09-18','Sep-2025' ),
('-280', '2025-09-17','Sep-2025' ),
('-279', '2025-09-16','Sep-2025' ),
('-278', '2025-09-15','Sep-2025' ),
('-277', '2025-09-14','Sep-2025' ),
('-276', '2025-09-13','Sep-2025' ),
('-275', '2025-09-12','Sep-2025' ),
('-274', '2025-09-11','Sep-2025' ),
('-273', '2025-09-10','Sep-2025' ),
('-272', '2025-09-09','Sep-2025' ),
('-271', '2025-09-08','Sep-2025' ),
('-270', '2025-09-07','Sep-2025' ),
('-269', '2025-09-06','Sep-2025' ),
('-268', '2025-09-05','Sep-2025' ),
('-267', '2025-09-04','Sep-2025' ),
('-266', '2025-09-03','Sep-2025' ),
('-265', '2025-09-02','Sep-2025' ),
('-264', '2025-09-01','Sep-2025' ),
('-263', '2025-08-31','Aug-2025' ),
('-262', '2025-08-30','Aug-2025' ),
('-261', '2025-08-29','Aug-2025' ),
('-260', '2025-08-28','Aug-2025' ),
('-259', '2025-08-27','Aug-2025' ),
('-258', '2025-08-26','Aug-2025' ),
('-257', '2025-08-25','Aug-2025' ),
('-256', '2025-08-24','Aug-2025' ),
('-255', '2025-08-23','Aug-2025' ),
('-254', '2025-08-22','Aug-2025' ),
('-253', '2025-08-21','Aug-2025' ),
('-252', '2025-08-20','Aug-2025' ),
('-251', '2025-08-19','Aug-2025' ),
('-250', '2025-08-18','Aug-2025' ),
('-249', '2025-08-17','Aug-2025' ),
('-248', '2025-08-16','Aug-2025' ),
('-247', '2025-08-15','Aug-2025' ),
('-246', '2025-08-14','Aug-2025' ),
('-245', '2025-08-13','Aug-2025' ),
('-244', '2025-08-12','Aug-2025' ),
('-243', '2025-08-11','Aug-2025' ),
('-242', '2025-08-10','Aug-2025' ),
('-241', '2025-08-09','Aug-2025' ),
('-240', '2025-08-08','Aug-2025' ),
('-239', '2025-08-07','Aug-2025' ),
('-238', '2025-08-06','Aug-2025' ),
('-237', '2025-08-05','Aug-2025' ),
('-236', '2025-08-04','Aug-2025' ),
('-235', '2025-08-03','Aug-2025' ),
('-234', '2025-08-02','Aug-2025' ),
('-233', '2025-08-01','Aug-2025' ),
('-232', '2025-07-31','Jul-2025' ),
('-231', '2025-07-30','Jul-2025' ),
('-230', '2025-07-29','Jul-2025' ),
('-229', '2025-07-28','Jul-2025' ),
('-228', '2025-07-27','Jul-2025' ),
('-227', '2025-07-26','Jul-2025' ),
('-226', '2025-07-25','Jul-2025' ),
('-225', '2025-07-24','Jul-2025' ),
('-224', '2025-07-23','Jul-2025' ),
('-223', '2025-07-22','Jul-2025' ),
('-222', '2025-07-21','Jul-2025' ),
('-221', '2025-07-20','Jul-2025' ),
('-220', '2025-07-19','Jul-2025' ),
('-219', '2025-07-18','Jul-2025' ),
('-218', '2025-07-17','Jul-2025' ),
('-217', '2025-07-16','Jul-2025' ),
('-216', '2025-07-15','Jul-2025' ),
('-215', '2025-07-14','Jul-2025' ),
('-214', '2025-07-13','Jul-2025' ),
('-213', '2025-07-12','Jul-2025' ),
('-212', '2025-07-11','Jul-2025' ),
('-211', '2025-07-10','Jul-2025' ),
('-210', '2025-07-09','Jul-2025' ),
('-209', '2025-07-08','Jul-2025' ),
('-208', '2025-07-07','Jul-2025' ),
('-207', '2025-07-06','Jul-2025' ),
('-206', '2025-07-05','Jul-2025' ),
('-205', '2025-07-04','Jul-2025' ),
('-204', '2025-07-03','Jul-2025' ),
('-203', '2025-07-02','Jul-2025' ),
('-202', '2025-07-01','Jul-2025' ),
('-201', '2025-06-30','Jun-2025' ),
('-200', '2025-06-29','Jun-2025' ),
('-199', '2025-06-28','Jun-2025' ),
('-198', '2025-06-27','Jun-2025' ),
('-197', '2025-06-26','Jun-2025' ),
('-196', '2025-06-25','Jun-2025' ),
('-195', '2025-06-24','Jun-2025' ),
('-194', '2025-06-23','Jun-2025' ),
('-193', '2025-06-22','Jun-2025' ),
('-192', '2025-06-21','Jun-2025' ),
('-191', '2025-06-20','Jun-2025' ),
('-190', '2025-06-19','Jun-2025' ),
('-189', '2025-06-18','Jun-2025' ),
('-188', '2025-06-17','Jun-2025' ),
('-187', '2025-06-16','Jun-2025' ),
('-186', '2025-06-15','Jun-2025' ),
('-185', '2025-06-14','Jun-2025' ),
('-184', '2025-06-13','Jun-2025' ),
('-183', '2025-06-12','Jun-2025' ),
('-182', '2025-06-11','Jun-2025' ),
('-181', '2025-06-10','Jun-2025' ),
('-180', '2025-06-09','Jun-2025' ),
('-179', '2025-06-08','Jun-2025' ),
('-178', '2025-06-07','Jun-2025' ),
('-177', '2025-06-06','Jun-2025' ),
('-176', '2025-06-05','Jun-2025' ),
('-175', '2025-06-04','Jun-2025' ),
('-174', '2025-06-03','Jun-2025' ),
('-173', '2025-06-02','Jun-2025' ),
('-172', '2025-06-01','Jun-2025' ),
('-171', '2025-05-31','May-2025' ),
('-170', '2025-05-30','May-2025' ),
('-169', '2025-05-29','May-2025' ),
('-168', '2025-05-28','May-2025' ),
('-167', '2025-05-27','May-2025' ),
('-166', '2025-05-26','May-2025' ),
('-165', '2025-05-25','May-2025' ),
('-164', '2025-05-24','May-2025' ),
('-163', '2025-05-23','May-2025' ),
('-162', '2025-05-22','May-2025' ),
('-161', '2025-05-21','May-2025' ),
('-160', '2025-05-20','May-2025' ),
('-159', '2025-05-19','May-2025' ),
('-158', '2025-05-18','May-2025' ),
('-157', '2025-05-17','May-2025' ),
('-156', '2025-05-16','May-2025' ),
('-155', '2025-05-15','May-2025' ),
('-154', '2025-05-14','May-2025' ),
('-153', '2025-05-13','May-2025' ),
('-152', '2025-05-12','May-2025' ),
('-151', '2025-05-11','May-2025' ),
('-150', '2025-05-10','May-2025' ),
('-149', '2025-05-09','May-2025' ),
('-148', '2025-05-08','May-2025' ),
('-147', '2025-05-07','May-2025' ),
('-146', '2025-05-06','May-2025' ),
('-145', '2025-05-05','May-2025' ),
('-144', '2025-05-04','May-2025' ),
('-143', '2025-05-03','May-2025' ),
('-142', '2025-05-02','May-2025' ),
('-141', '2025-05-01','May-2025' ),
('-140', '2025-04-30','Apr-2025' ),
('-139', '2025-04-29','Apr-2025' ),
('-138', '2025-04-28','Apr-2025' ),
('-137', '2025-04-27','Apr-2025' ),
('-136', '2025-04-26','Apr-2025' ),
('-135', '2025-04-25','Apr-2025' ),
('-134', '2025-04-24','Apr-2025' ),
('-133', '2025-04-23','Apr-2025' ),
('-132', '2025-04-22','Apr-2025' ),
('-131', '2025-04-21','Apr-2025' ),
('-130', '2025-04-20','Apr-2025' ),
('-129', '2025-04-19','Apr-2025' ),
('-128', '2025-04-18','Apr-2025' ),
('-127', '2025-04-17','Apr-2025' ),
('-126', '2025-04-16','Apr-2025' ),
('-125', '2025-04-15','Apr-2025' ),
('-124', '2025-04-14','Apr-2025' ),
('-123', '2025-04-13','Apr-2025' ),
('-122', '2025-04-12','Apr-2025' ),
('-121', '2025-04-11','Apr-2025' ),
('-120', '2025-04-10','Apr-2025' ),
('-119', '2025-04-09','Apr-2025' ),
('-118', '2025-04-08','Apr-2025' ),
('-117', '2025-04-07','Apr-2025' ),
('-116', '2025-04-06','Apr-2025' ),
('-115', '2025-04-05','Apr-2025' ),
('-114', '2025-04-04','Apr-2025' ),
('-113', '2025-04-03','Apr-2025' ),
('-112', '2025-04-02','Apr-2025' ),
('-111', '2025-04-01','Apr-2025' ),
('-110', '2025-03-31','Mar-2025' ),
('-109', '2025-03-30','Mar-2025' ),
('-108', '2025-03-29','Mar-2025' ),
('-107', '2025-03-28','Mar-2025' ),
('-106', '2025-03-27','Mar-2025' ),
('-105', '2025-03-26','Mar-2025' ),
('-104', '2025-03-25','Mar-2025' ),
('-103', '2025-03-24','Mar-2025' ),
('-102', '2025-03-23','Mar-2025' ),
('-101', '2025-03-22','Mar-2025' ),
('-100', '2025-03-21','Mar-2025' ),
('-99', '2025-03-20','Mar-2025' ),
('-98', '2025-03-19','Mar-2025' ),
('-97', '2025-03-18','Mar-2025' ),
('-96', '2025-03-17','Mar-2025' ),
('-95', '2025-03-16','Mar-2025' ),
('-94', '2025-03-15','Mar-2025' ),
('-93', '2025-03-14','Mar-2025' ),
('-92', '2025-03-13','Mar-2025' ),
('-91', '2025-03-12','Mar-2025' ),
('-90', '2025-03-11','Mar-2025' ),
('-89', '2025-03-10','Mar-2025' ),
('-88', '2025-03-09','Mar-2025' ),
('-87', '2025-03-08','Mar-2025' ),
('-86', '2025-03-07','Mar-2025' ),
('-85', '2025-03-06','Mar-2025' ),
('-84', '2025-03-05','Mar-2025' ),
('-83', '2025-03-04','Mar-2025' ),
('-82', '2025-03-03','Mar-2025' ),
('-81', '2025-03-02','Mar-2025' ),
('-80', '2025-03-01','Mar-2025' ),
('-79', '2025-02-28','Feb-2025' ),
('-78', '2025-02-27','Feb-2025' ),
('-77', '2025-02-26','Feb-2025' ),
('-76', '2025-02-25','Feb-2025' ),
('-75', '2025-02-24','Feb-2025' ),
('-74', '2025-02-23','Feb-2025' ),
('-73', '2025-02-22','Feb-2025' ),
('-72', '2025-02-21','Feb-2025' ),
('-71', '2025-02-20','Feb-2025' ),
('-70', '2025-02-19','Feb-2025' ),
('-69', '2025-02-18','Feb-2025' ),
('-68', '2025-02-17','Feb-2025' ),
('-67', '2025-02-16','Feb-2025' ),
('-66', '2025-02-15','Feb-2025' ),
('-65', '2025-02-14','Feb-2025' ),
('-64', '2025-02-13','Feb-2025' ),
('-63', '2025-02-12','Feb-2025' ),
('-62', '2025-02-11','Feb-2025' ),
('-61', '2025-02-10','Feb-2025' ),
('-60', '2025-02-09','Feb-2025' ),
('-59', '2025-02-08','Feb-2025' ),
('-58', '2025-02-07','Feb-2025' ),
('-57', '2025-02-06','Feb-2025' ),
('-56', '2025-02-05','Feb-2025' ),
('-55', '2025-02-04','Feb-2025' ),
('-54', '2025-02-03','Feb-2025' ),
('-53', '2025-02-02','Feb-2025' ),
('-52', '2025-02-01','Feb-2025' ),
('-51', '2025-01-31','Jan-2025' ),
('-50', '2025-01-30','Jan-2025' ),
('-49', '2025-01-29','Jan-2025' ),
('-48', '2025-01-28','Jan-2025' ),
('-47', '2025-01-27','Jan-2025' ),
('-46', '2025-01-26','Jan-2025' ),
('-45', '2025-01-25','Jan-2025' ),
('-44', '2025-01-24','Jan-2025' ),
('-43', '2025-01-23','Jan-2025' ),
('-42', '2025-01-22','Jan-2025' ),
('-41', '2025-01-21','Jan-2025' ),
('-40', '2025-01-20','Jan-2025' ),
('-39', '2025-01-19','Jan-2025' ),
('-38', '2025-01-18','Jan-2025' ),
('-37', '2025-01-17','Jan-2025' ),
('-36', '2025-01-16','Jan-2025' ),
('-35', '2025-01-15','Jan-2025' ),
('-34', '2025-01-14','Jan-2025' ),
('-33', '2025-01-13','Jan-2025' ),
('-32', '2025-01-12','Jan-2025' ),
('-31', '2025-01-11','Jan-2025' ),
('-30', '2025-01-10','Jan-2025' ),
('-29', '2025-01-09','Jan-2025' ),
('-28', '2025-01-08','Jan-2025' ),
('-27', '2025-01-07','Jan-2025' ),
('-26', '2025-01-06','Jan-2025' ),
('-25', '2025-01-05','Jan-2025' ),
('-24', '2025-01-04','Jan-2025' ),
('-23', '2025-01-03','Jan-2025' ),
('-22', '2025-01-02','Jan-2025' ),
('-21', '2025-01-01','Jan-2025' ),
('-20', '2024-12-31','Dec-2024' ),
('-19', '2024-12-30','Dec-2024' ),
('-18', '2024-12-29','Dec-2024' ),
('-17', '2024-12-28','Dec-2024' ),
('-16', '2024-12-27','Dec-2024' ),
('-15', '2024-12-26','Dec-2024' ),
('-14', '2024-12-25','Dec-2024' ),
('-13', '2024-12-24','Dec-2024' ),
('-12', '2024-12-23','Dec-2024' ),
('-11', '2024-12-22','Dec-2024' ),
('-10', '2024-12-21','Dec-2024' ),
('-9', '2024-12-20','Dec-2024' ),
('-8', '2024-12-19','Dec-2024' ),
('-7', '2024-12-18','Dec-2024' ),
('-6', '2024-12-17','Dec-2024' ),
('-5', '2024-12-16','Dec-2024' ),
('-4', '2024-12-15','Dec-2024' ),
('-3', '2024-12-14','Dec-2024' ),
('-2', '2024-12-13','Dec-2024' ),
('-1', '2024-12-12','Dec-2024' ),
('0', '2024-12-11','Dec-2024' ),
('1', '2024-12-10','Dec-2024' ),
('2', '2024-12-09','Dec-2024' ),
('3', '2024-12-08','Dec-2024' ),
('4', '2024-12-07','Dec-2024' ),
('5', '2024-12-06','Dec-2024' ),
('6', '2024-12-05','Dec-2024' ),
('7', '2024-12-04','Dec-2024' ),
('8', '2024-12-03','Dec-2024' ),
('9', '2024-12-02','Dec-2024' ),
('10', '2024-12-01','Dec-2024' ),
('11', '2024-11-30','Nov-2024' ),
('12', '2024-11-29','Nov-2024' ),
('13', '2024-11-28','Nov-2024' ),
('14', '2024-11-27','Nov-2024' ),
('15', '2024-11-26','Nov-2024' ),
('16', '2024-11-25','Nov-2024' ),
('17', '2024-11-24','Nov-2024' ),
('18', '2024-11-23','Nov-2024' ),
('19', '2024-11-22','Nov-2024' ),
('20', '2024-11-21','Nov-2024' ),
('21', '2024-11-20','Nov-2024' ),
('22', '2024-11-19','Nov-2024' ),
('23', '2024-11-18','Nov-2024' ),
('24', '2024-11-17','Nov-2024' ),
('25', '2024-11-16','Nov-2024' ),
('26', '2024-11-15','Nov-2024' ),
('27', '2024-11-14','Nov-2024' ),
('28', '2024-11-13','Nov-2024' ),
('29', '2024-11-12','Nov-2024' ),
('30', '2024-11-11','Nov-2024' ),
('31', '2024-11-10','Nov-2024' ),
('32', '2024-11-09','Nov-2024' ),
('33', '2024-11-08','Nov-2024' ),
('34', '2024-11-07','Nov-2024' ),
('35', '2024-11-06','Nov-2024' ),
('36', '2024-11-05','Nov-2024' ),
('37', '2024-11-04','Nov-2024' ),
('38', '2024-11-03','Nov-2024' ),
('39', '2024-11-02','Nov-2024' ),
('40', '2024-11-01','Nov-2024' ),
('41', '2024-10-31','Oct-2024' ),
('42', '2024-10-30','Oct-2024' ),
('43', '2024-10-29','Oct-2024' ),
('44', '2024-10-28','Oct-2024' ),
('45', '2024-10-27','Oct-2024' ),
('46', '2024-10-26','Oct-2024' ),
('47', '2024-10-25','Oct-2024' ),
('48', '2024-10-24','Oct-2024' ),
('49', '2024-10-23','Oct-2024' ),
('50', '2024-10-22','Oct-2024' ),
('51', '2024-10-21','Oct-2024' ),
('52', '2024-10-20','Oct-2024' ),
('53', '2024-10-19','Oct-2024' ),
('54', '2024-10-18','Oct-2024' ),
('55', '2024-10-17','Oct-2024' ),
('56', '2024-10-16','Oct-2024' ),
('57', '2024-10-15','Oct-2024' ),
('58', '2024-10-14','Oct-2024' ),
('59', '2024-10-13','Oct-2024' ),
('60', '2024-10-12','Oct-2024' ),
('61', '2024-10-11','Oct-2024' ),
('62', '2024-10-10','Oct-2024' ),
('63', '2024-10-09','Oct-2024' ),
('64', '2024-10-08','Oct-2024' ),
('65', '2024-10-07','Oct-2024' ),
('66', '2024-10-06','Oct-2024' ),
('67', '2024-10-05','Oct-2024' ),
('68', '2024-10-04','Oct-2024' ),
('69', '2024-10-03','Oct-2024' ),
('70', '2024-10-02','Oct-2024' ),
('71', '2024-10-01','Oct-2024' ),
('72', '2024-09-30','Sep-2024' ),
('73', '2024-09-29','Sep-2024' ),
('74', '2024-09-28','Sep-2024' ),
('75', '2024-09-27','Sep-2024' ),
('76', '2024-09-26','Sep-2024' ),
('77', '2024-09-25','Sep-2024' ),
('78', '2024-09-24','Sep-2024' ),
('79', '2024-09-23','Sep-2024' ),
('80', '2024-09-22','Sep-2024' ),
('81', '2024-09-21','Sep-2024' ),
('82', '2024-09-20','Sep-2024' ),
('83', '2024-09-19','Sep-2024' ),
('84', '2024-09-18','Sep-2024' ),
('85', '2024-09-17','Sep-2024' ),
('86', '2024-09-16','Sep-2024' ),
('87', '2024-09-15','Sep-2024' ),
('88', '2024-09-14','Sep-2024' ),
('89', '2024-09-13','Sep-2024' ),
('90', '2024-09-12','Sep-2024' ),
('91', '2024-09-11','Sep-2024' ),
('92', '2024-09-10','Sep-2024' ),
('93', '2024-09-09','Sep-2024' ),
('94', '2024-09-08','Sep-2024' ),
('95', '2024-09-07','Sep-2024' ),
('96', '2024-09-06','Sep-2024' ),
('97', '2024-09-05','Sep-2024' ),
('98', '2024-09-04','Sep-2024' ),
('99', '2024-09-03','Sep-2024' ),
('100', '2024-09-02','Sep-2024' ),
('101', '2024-09-01','Sep-2024' ),
('102', '2024-08-31','Aug-2024' ),
('103', '2024-08-30','Aug-2024' ),
('104', '2024-08-29','Aug-2024' ),
('105', '2024-08-28','Aug-2024' ),
('106', '2024-08-27','Aug-2024' ),
('107', '2024-08-26','Aug-2024' ),
('108', '2024-08-25','Aug-2024' ),
('109', '2024-08-24','Aug-2024' ),
('110', '2024-08-23','Aug-2024' ),
('111', '2024-08-22','Aug-2024' ),
('112', '2024-08-21','Aug-2024' ),
('113', '2024-08-20','Aug-2024' ),
('114', '2024-08-19','Aug-2024' ),
('115', '2024-08-18','Aug-2024' ),
('116', '2024-08-17','Aug-2024' ),
('117', '2024-08-16','Aug-2024' ),
('118', '2024-08-15','Aug-2024' ),
('119', '2024-08-14','Aug-2024' ),
('120', '2024-08-13','Aug-2024' ),
('121', '2024-08-12','Aug-2024' ),
('122', '2024-08-11','Aug-2024' ),
('123', '2024-08-10','Aug-2024' ),
('124', '2024-08-09','Aug-2024' ),
('125', '2024-08-08','Aug-2024' ),
('126', '2024-08-07','Aug-2024' ),
('127', '2024-08-06','Aug-2024' ),
('128', '2024-08-05','Aug-2024' ),
('129', '2024-08-04','Aug-2024' ),
('130', '2024-08-03','Aug-2024' ),
('131', '2024-08-02','Aug-2024' ),
('132', '2024-08-01','Aug-2024' ),
('133', '2024-07-31','Jul-2024' ),
('134', '2024-07-30','Jul-2024' ),
('135', '2024-07-29','Jul-2024' ),
('136', '2024-07-28','Jul-2024' ),
('137', '2024-07-27','Jul-2024' ),
('138', '2024-07-26','Jul-2024' ),
('139', '2024-07-25','Jul-2024' ),
('140', '2024-07-24','Jul-2024' ),
('141', '2024-07-23','Jul-2024' ),
('142', '2024-07-22','Jul-2024' ),
('143', '2024-07-21','Jul-2024' ),
('144', '2024-07-20','Jul-2024' ),
('145', '2024-07-19','Jul-2024' ),
('146', '2024-07-18','Jul-2024' ),
('147', '2024-07-17','Jul-2024' ),
('148', '2024-07-16','Jul-2024' ),
('149', '2024-07-15','Jul-2024' ),
('150', '2024-07-14','Jul-2024' ),
('151', '2024-07-13','Jul-2024' ),
('152', '2024-07-12','Jul-2024' ),
('153', '2024-07-11','Jul-2024' ),
('154', '2024-07-10','Jul-2024' ),
('155', '2024-07-09','Jul-2024' ),
('156', '2024-07-08','Jul-2024' ),
('157', '2024-07-07','Jul-2024' ),
('158', '2024-07-06','Jul-2024' ),
('159', '2024-07-05','Jul-2024' ),
('160', '2024-07-04','Jul-2024' ),
('161', '2024-07-03','Jul-2024' ),
('162', '2024-07-02','Jul-2024' ),
('163', '2024-07-01','Jul-2024' ),
('164', '2024-06-30','Jun-2024' ),
('165', '2024-06-29','Jun-2024' ),
('166', '2024-06-28','Jun-2024' ),
('167', '2024-06-27','Jun-2024' ),
('168', '2024-06-26','Jun-2024' ),
('169', '2024-06-25','Jun-2024' ),
('170', '2024-06-24','Jun-2024' ),
('171', '2024-06-23','Jun-2024' ),
('172', '2024-06-22','Jun-2024' ),
('173', '2024-06-21','Jun-2024' ),
('174', '2024-06-20','Jun-2024' ),
('175', '2024-06-19','Jun-2024' ),
('176', '2024-06-18','Jun-2024' ),
('177', '2024-06-17','Jun-2024' ),
('178', '2024-06-16','Jun-2024' ),
('179', '2024-06-15','Jun-2024' ),
('180', '2024-06-14','Jun-2024' ),
('181', '2024-06-13','Jun-2024' ),
('182', '2024-06-12','Jun-2024' ),
('183', '2024-06-11','Jun-2024' ),
('184', '2024-06-10','Jun-2024' ),
('185', '2024-06-09','Jun-2024' ),
('186', '2024-06-08','Jun-2024' ),
('187', '2024-06-07','Jun-2024' ),
('188', '2024-06-06','Jun-2024' ),
('189', '2024-06-05','Jun-2024' ),
('190', '2024-06-04','Jun-2024' ),
('191', '2024-06-03','Jun-2024' ),
('192', '2024-06-02','Jun-2024' ),
('193', '2024-06-01','Jun-2024' ),
('194', '2024-05-31','May-2024' ),
('195', '2024-05-30','May-2024' ),
('196', '2024-05-29','May-2024' ),
('197', '2024-05-28','May-2024' ),
('198', '2024-05-27','May-2024' ),
('199', '2024-05-26','May-2024' ),
('200', '2024-05-25','May-2024' ),
('201', '2024-05-24','May-2024' ),
('202', '2024-05-23','May-2024' ),
('203', '2024-05-22','May-2024' ),
('204', '2024-05-21','May-2024' ),
('205', '2024-05-20','May-2024' ),
('206', '2024-05-19','May-2024' ),
('207', '2024-05-18','May-2024' ),
('208', '2024-05-17','May-2024' ),
('209', '2024-05-16','May-2024' ),
('210', '2024-05-15','May-2024' ),
('211', '2024-05-14','May-2024' ),
('212', '2024-05-13','May-2024' ),
('213', '2024-05-12','May-2024' ),
('214', '2024-05-11','May-2024' ),
('215', '2024-05-10','May-2024' ),
('216', '2024-05-09','May-2024' ),
('217', '2024-05-08','May-2024' ),
('218', '2024-05-07','May-2024' ),
('219', '2024-05-06','May-2024' ),
('220', '2024-05-05','May-2024' ),
('221', '2024-05-04','May-2024' ),
('222', '2024-05-03','May-2024' ),
('223', '2024-05-02','May-2024' ),
('224', '2024-05-01','May-2024' ),
('225', '2024-04-30','Apr-2024' ),
('226', '2024-04-29','Apr-2024' ),
('227', '2024-04-28','Apr-2024' ),
('228', '2024-04-27','Apr-2024' ),
('229', '2024-04-26','Apr-2024' ),
('230', '2024-04-25','Apr-2024' ),
('231', '2024-04-24','Apr-2024' ),
('232', '2024-04-23','Apr-2024' ),
('233', '2024-04-22','Apr-2024' ),
('234', '2024-04-21','Apr-2024' ),
('235', '2024-04-20','Apr-2024' ),
('236', '2024-04-19','Apr-2024' ),
('237', '2024-04-18','Apr-2024' ),
('238', '2024-04-17','Apr-2024' ),
('239', '2024-04-16','Apr-2024' ),
('240', '2024-04-15','Apr-2024' ),
('241', '2024-04-14','Apr-2024' ),
('242', '2024-04-13','Apr-2024' ),
('243', '2024-04-12','Apr-2024' ),
('244', '2024-04-11','Apr-2024' ),
('245', '2024-04-10','Apr-2024' ),
('246', '2024-04-09','Apr-2024' ),
('247', '2024-04-08','Apr-2024' ),
('248', '2024-04-07','Apr-2024' ),
('249', '2024-04-06','Apr-2024' ),
('250', '2024-04-05','Apr-2024' ),
('251', '2024-04-04','Apr-2024' ),
('252', '2024-04-03','Apr-2024' ),
('253', '2024-04-02','Apr-2024' ),
('254', '2024-04-01','Apr-2024' ),
('255', '2024-03-31','Mar-2024' ),
('256', '2024-03-30','Mar-2024' ),
('257', '2024-03-29','Mar-2024' ),
('258', '2024-03-28','Mar-2024' ),
('259', '2024-03-27','Mar-2024' ),
('260', '2024-03-26','Mar-2024' ),
('261', '2024-03-25','Mar-2024' ),
('262', '2024-03-24','Mar-2024' ),
('263', '2024-03-23','Mar-2024' ),
('264', '2024-03-22','Mar-2024' ),
('265', '2024-03-21','Mar-2024' ),
('266', '2024-03-20','Mar-2024' ),
('267', '2024-03-19','Mar-2024' ),
('268', '2024-03-18','Mar-2024' ),
('269', '2024-03-17','Mar-2024' ),
('270', '2024-03-16','Mar-2024' ),
('271', '2024-03-15','Mar-2024' ),
('272', '2024-03-14','Mar-2024' ),
('273', '2024-03-13','Mar-2024' ),
('274', '2024-03-12','Mar-2024' ),
('275', '2024-03-11','Mar-2024' ),
('276', '2024-03-10','Mar-2024' ),
('277', '2024-03-09','Mar-2024' ),
('278', '2024-03-08','Mar-2024' ),
('279', '2024-03-07','Mar-2024' ),
('280', '2024-03-06','Mar-2024' ),
('281', '2024-03-05','Mar-2024' ),
('282', '2024-03-04','Mar-2024' ),
('283', '2024-03-03','Mar-2024' ),
('284', '2024-03-02','Mar-2024' ),
('285', '2024-03-01','Mar-2024' ),
('286', '2024-02-29','Feb-2024' ),
('287', '2024-02-28','Feb-2024' ),
('288', '2024-02-27','Feb-2024' ),
('289', '2024-02-26','Feb-2024' ),
('290', '2024-02-25','Feb-2024' ),
('291', '2024-02-24','Feb-2024' ),
('292', '2024-02-23','Feb-2024' ),
('293', '2024-02-22','Feb-2024' ),
('294', '2024-02-21','Feb-2024' ),
('295', '2024-02-20','Feb-2024' ),
('296', '2024-02-19','Feb-2024' ),
('297', '2024-02-18','Feb-2024' ),
('298', '2024-02-17','Feb-2024' ),
('299', '2024-02-16','Feb-2024' ),
('300', '2024-02-15','Feb-2024' ),
('301', '2024-02-14','Feb-2024' ),
('302', '2024-02-13','Feb-2024' ),
('303', '2024-02-12','Feb-2024' ),
('304', '2024-02-11','Feb-2024' ),
('305', '2024-02-10','Feb-2024' ),
('306', '2024-02-09','Feb-2024' ),
('307', '2024-02-08','Feb-2024' ),
('308', '2024-02-07','Feb-2024' ),
('309', '2024-02-06','Feb-2024' ),
('310', '2024-02-05','Feb-2024' ),
('311', '2024-02-04','Feb-2024' ),
('312', '2024-02-03','Feb-2024' ),
('313', '2024-02-02','Feb-2024' ),
('314', '2024-02-01','Feb-2024' ),
('315', '2024-01-31','Jan-2024' ),
('316', '2024-01-30','Jan-2024' ),
('317', '2024-01-29','Jan-2024' ),
('318', '2024-01-28','Jan-2024' ),
('319', '2024-01-27','Jan-2024' ),
('320', '2024-01-26','Jan-2024' ),
('321', '2024-01-25','Jan-2024' ),
('322', '2024-01-24','Jan-2024' ),
('323', '2024-01-23','Jan-2024' ),
('324', '2024-01-22','Jan-2024' ),
('325', '2024-01-21','Jan-2024' ),
('326', '2024-01-20','Jan-2024' ),
('327', '2024-01-19','Jan-2024' ),
('328', '2024-01-18','Jan-2024' ),
('329', '2024-01-17','Jan-2024' ),
('330', '2024-01-16','Jan-2024' ),
('331', '2024-01-15','Jan-2024' ),
('332', '2024-01-14','Jan-2024' ),
('333', '2024-01-13','Jan-2024' ),
('334', '2024-01-12','Jan-2024' ),
('335', '2024-01-11','Jan-2024' ),
('336', '2024-01-10','Jan-2024' ),
('337', '2024-01-09','Jan-2024' ),
('338', '2024-01-08','Jan-2024' ),
('339', '2024-01-07','Jan-2024' ),
('340', '2024-01-06','Jan-2024' ),
('341', '2024-01-05','Jan-2024' ),
('342', '2024-01-04','Jan-2024' ),
('343', '2024-01-03','Jan-2024' ),
('344', '2024-01-02','Jan-2024' ),
('345', '2024-01-01','Jan-2024' ),
('346', '2023-12-31','Dec-2023' ),
('347', '2023-12-30','Dec-2023' ),
('348', '2023-12-29','Dec-2023' ),
('349', '2023-12-28','Dec-2023' ),
('350', '2023-12-27','Dec-2023' ),
('351', '2023-12-26','Dec-2023' ),
('352', '2023-12-25','Dec-2023' ),
('353', '2023-12-24','Dec-2023' ),
('354', '2023-12-23','Dec-2023' ),
('355', '2023-12-22','Dec-2023' ),
('356', '2023-12-21','Dec-2023' ),
('357', '2023-12-20','Dec-2023' ),
('358', '2023-12-19','Dec-2023' ),
('359', '2023-12-18','Dec-2023' ),
('360', '2023-12-17','Dec-2023' ),
('361', '2023-12-16','Dec-2023' ),
('362', '2023-12-15','Dec-2023' ),
('363', '2023-12-14','Dec-2023' ),
('364', '2023-12-13','Dec-2023' ),
('365', '2023-12-12','Dec-2023' ),
('366', '2023-12-11','Dec-2023' ),
('367', '2023-12-10','Dec-2023' ),
('368', '2023-12-09','Dec-2023' ),
('369', '2023-12-08','Dec-2023' ),
('370', '2023-12-07','Dec-2023' );

Records of different date ranges by using DATE_SUB(), CURDATE() and BETWEEN() query.

Use this to add records for query in the range of 3 months to 12 months.

INSERT INTO `dt_table` VALUES ('-380', '2023-11-27','Nov-2023' ); 
INSERT INTO `dt_table` VALUES ('-370', '2023-12-07','Dec-2023' ); 
INSERT INTO `dt_table` VALUES ('-360', '2023-12-17','Dec-2023' ); 
INSERT INTO `dt_table` VALUES ('-350', '2023-12-27','Dec-2023' ); 
INSERT INTO `dt_table` VALUES ('-340', '2024-01-06','Jan-2024' ); 
INSERT INTO `dt_table` VALUES ('-330', '2024-01-16','Jan-2024' ); 
INSERT INTO `dt_table` VALUES ('-320', '2024-01-26','Jan-2024' ); 
INSERT INTO `dt_table` VALUES ('-310', '2024-02-05','Feb-2024' ); 
INSERT INTO `dt_table` VALUES ('-300', '2024-02-15','Feb-2024' ); 
INSERT INTO `dt_table` VALUES ('-290', '2024-02-25','Feb-2024' ); 
INSERT INTO `dt_table` VALUES ('-280', '2024-03-06','Mar-2024' ); 
INSERT INTO `dt_table` VALUES ('-270', '2024-03-16','Mar-2024' ); 
INSERT INTO `dt_table` VALUES ('-260', '2024-03-26','Mar-2024' ); 
INSERT INTO `dt_table` VALUES ('-250', '2024-04-05','Apr-2024' ); 
INSERT INTO `dt_table` VALUES ('-240', '2024-04-15','Apr-2024' ); 
INSERT INTO `dt_table` VALUES ('-230', '2024-04-25','Apr-2024' ); 
INSERT INTO `dt_table` VALUES ('-220', '2024-05-05','May-2024' ); 
INSERT INTO `dt_table` VALUES ('-210', '2024-05-15','May-2024' ); 
INSERT INTO `dt_table` VALUES ('-200', '2024-05-25','May-2024' ); 
INSERT INTO `dt_table` VALUES ('-190', '2024-06-04','Jun-2024' ); 
INSERT INTO `dt_table` VALUES ('-180', '2024-06-14','Jun-2024' ); 
INSERT INTO `dt_table` VALUES ('-170', '2024-06-24','Jun-2024' ); 
INSERT INTO `dt_table` VALUES ('-160', '2024-07-04','Jul-2024' ); 
INSERT INTO `dt_table` VALUES ('-150', '2024-07-14','Jul-2024' ); 
INSERT INTO `dt_table` VALUES ('-140', '2024-07-24','Jul-2024' ); 
INSERT INTO `dt_table` VALUES ('-130', '2024-08-03','Aug-2024' ); 
INSERT INTO `dt_table` VALUES ('-120', '2024-08-13','Aug-2024' ); 
INSERT INTO `dt_table` VALUES ('-110', '2024-08-23','Aug-2024' ); 
INSERT INTO `dt_table` VALUES ('-100', '2024-09-02','Sep-2024' ); 
INSERT INTO `dt_table` VALUES ('-90', '2024-09-12','Sep-2024' ); 
INSERT INTO `dt_table` VALUES ('-80', '2024-09-22','Sep-2024' ); 
INSERT INTO `dt_table` VALUES ('-70', '2024-10-02','Oct-2024' ); 
INSERT INTO `dt_table` VALUES ('-60', '2024-10-12','Oct-2024' ); 
INSERT INTO `dt_table` VALUES ('-50', '2024-10-22','Oct-2024' ); 
INSERT INTO `dt_table` VALUES ('-40', '2024-11-01','Nov-2024' ); 
INSERT INTO `dt_table` VALUES ('-30', '2024-11-11','Nov-2024' ); 
INSERT INTO `dt_table` VALUES ('-20', '2024-11-21','Nov-2024' ); 
INSERT INTO `dt_table` VALUES ('-10', '2024-12-01','Dec-2024' ); 
INSERT INTO `dt_table` VALUES ('0', '2024-12-11','Dec-2024' ); 
INSERT INTO `dt_table` VALUES ('10', '2024-12-21','Dec-2024' ); 
INSERT INTO `dt_table` VALUES ('20', '2024-12-31','Dec-2024' ); 
INSERT INTO `dt_table` VALUES ('30', '2025-01-10','Jan-2025' );

Table with date and time dt_table_tm

CREATE TABLE IF NOT EXISTS `dt_table_tm` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `tm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `dt_table_tm` VALUES ('2', '2024-12-11 12:38:54'); 
INSERT INTO `dt_table_tm` VALUES ('3', '2024-12-11 18:29:39'); 
INSERT INTO `dt_table_tm` VALUES ('4', '2024-12-11 18:55:58'); 
INSERT INTO `dt_table_tm` VALUES ('5', '2024-12-10 10:35:40'); 
INSERT INTO `dt_table_tm` VALUES ('6', '2024-12-10 17:6:57'); 
INSERT INTO `dt_table_tm` VALUES ('7', '2024-12-10 16:41:38'); 
INSERT INTO `dt_table_tm` VALUES ('8', '2024-12-09 14:45:53'); 
INSERT INTO `dt_table_tm` VALUES ('9', '2024-12-09 13:53:16'); 
INSERT INTO `dt_table_tm` VALUES ('10', '2024-12-09 12:10:59'); 
INSERT INTO `dt_table_tm` VALUES ('11', '2024-12-08 15:45:41'); 
INSERT INTO `dt_table_tm` VALUES ('12', '2024-12-08 9:38:44'); 
INSERT INTO `dt_table_tm` VALUES ('13', '2024-12-08 17:58:19'); 
INSERT INTO `dt_table_tm` VALUES ('14', '2024-12-07 12:6:6'); 
INSERT INTO `dt_table_tm` VALUES ('15', '2024-12-07 10:5:21'); 
INSERT INTO `dt_table_tm` VALUES ('16', '2024-12-07 16:16:43'); 
INSERT INTO `dt_table_tm` VALUES ('17', '2024-12-06 15:37:33'); 
INSERT INTO `dt_table_tm` VALUES ('18', '2024-12-06 9:34:0'); 
INSERT INTO `dt_table_tm` VALUES ('19', '2024-12-06 16:20:52'); 
INSERT INTO `dt_table_tm` VALUES ('20', '2024-12-05 18:11:8'); 
INSERT INTO `dt_table_tm` VALUES ('21', '2024-12-05 12:3:41'); 
INSERT INTO `dt_table_tm` VALUES ('22', '2024-12-05 18:50:59'); 
INSERT INTO `dt_table_tm` VALUES ('23', '2024-12-04 9:48:52'); 
INSERT INTO `dt_table_tm` VALUES ('24', '2024-12-04 16:30:47'); 
INSERT INTO `dt_table_tm` VALUES ('25', '2024-12-04 9:48:27'); 
INSERT INTO `dt_table_tm` VALUES ('26', '2024-12-03 9:7:7'); 
INSERT INTO `dt_table_tm` VALUES ('27', '2024-12-03 17:6:44'); 
INSERT INTO `dt_table_tm` VALUES ('28', '2024-12-03 15:45:2'); 
INSERT INTO `dt_table_tm` VALUES ('29', '2024-12-02 16:0:22'); 
INSERT INTO `dt_table_tm` VALUES ('30', '2024-12-02 15:35:27'); 
INSERT INTO `dt_table_tm` VALUES ('31', '2024-12-02 18:53:37'); 
INSERT INTO `dt_table_tm` VALUES ('32', '2024-12-01 14:23:15'); 
INSERT INTO `dt_table_tm` VALUES ('33', '2024-12-01 13:29:38'); 
INSERT INTO `dt_table_tm` VALUES ('34', '2024-12-01 14:37:32'); 
INSERT INTO `dt_table_tm` VALUES ('35', '2024-11-30 12:21:3'); 
INSERT INTO `dt_table_tm` VALUES ('36', '2024-11-30 13:4:48'); 
INSERT INTO `dt_table_tm` VALUES ('37', '2024-11-30 12:40:31'); 
INSERT INTO `dt_table_tm` VALUES ('38', '2024-11-29 12:53:3'); 
INSERT INTO `dt_table_tm` VALUES ('39', '2024-11-29 13:17:40'); 
INSERT INTO `dt_table_tm` VALUES ('40', '2024-11-29 18:9:25'); 
INSERT INTO `dt_table_tm` VALUES ('41', '2024-11-28 15:14:40'); 
INSERT INTO `dt_table_tm` VALUES ('42', '2024-11-28 9:39:41'); 
INSERT INTO `dt_table_tm` VALUES ('43', '2024-11-28 12:21:4');

Subscribe to our YouTube Channel here

SQL Dump for testing date & time query

Table with date and time dt_table_tm

Subscribe