Dynamic SQL Test Data for Date & Time Queries

These dumps are generated from today's date. Download or copy a fresh version when testing queries such as DATE_SUB() date ranges, BETWEEN, WEEK(), and WEEKOFYEAR().

Daily records: 370 days before and after today

CREATE TABLE IF NOT EXISTS `dt_table` (
  `record_id` INT NOT NULL,
  `date` DATE NOT NULL,
  `month_year` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`record_id`),
  KEY `idx_dt_table_date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

Fresh CSV: dt_table.php
!wget -O dt_table.csv https://www.plus2net.com/sql_tutorial/dt_table.php

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

Previous 12 months to future 3 months

This smaller dataset inserts one row every 10 days from about one year ago through about three months ahead.

INSERT INTO `dt_table` (`record_id`,`date`,`month_year`) VALUES
('-365', '2025-09-29', 'Sep-2025'),
('-355', '2025-10-09', 'Oct-2025'),
('-345', '2025-10-19', 'Oct-2025'),
('-335', '2025-10-29', 'Oct-2025'),
('-325', '2025-11-08', 'Nov-2025'),
('-315', '2025-11-18', 'Nov-2025'),
('-305', '2025-11-28', 'Nov-2025'),
('-295', '2025-12-08', 'Dec-2025'),
('-285', '2025-12-18', 'Dec-2025'),
('-275', '2025-12-28', 'Dec-2025'),
('-265', '2026-01-07', 'Jan-2026'),
('-255', '2026-01-17', 'Jan-2026'),
('-245', '2026-01-27', 'Jan-2026'),
('-235', '2026-02-06', 'Feb-2026'),
('-225', '2026-02-16', 'Feb-2026'),
('-215', '2026-02-26', 'Feb-2026'),
('-205', '2026-03-08', 'Mar-2026'),
('-195', '2026-03-18', 'Mar-2026'),
('-185', '2026-03-28', 'Mar-2026'),
('-175', '2026-04-07', 'Apr-2026'),
('-165', '2026-04-17', 'Apr-2026'),
('-155', '2026-04-27', 'Apr-2026'),
('-145', '2026-05-07', 'May-2026'),
('-135', '2026-05-17', 'May-2026'),
('-125', '2026-05-27', 'May-2026'),
('-115', '2026-06-06', 'Jun-2026'),
('-105', '2026-06-16', 'Jun-2026'),
('-95', '2026-06-26', 'Jun-2026'),
('-85', '2026-07-06', 'Jul-2026'),
('-75', '2026-07-16', 'Jul-2026'),
('-65', '2026-07-26', 'Jul-2026'),
('-55', '2026-08-05', 'Aug-2026'),
('-45', '2026-08-15', 'Aug-2026'),
('-35', '2026-08-25', 'Aug-2026'),
('-25', '2026-09-04', 'Sep-2026'),
('-15', '2026-09-14', 'Sep-2026'),
('-5', '2026-09-24', 'Sep-2026'),
('5', '2026-10-04', 'Oct-2026'),
('15', '2026-10-14', 'Oct-2026'),
('25', '2026-10-24', 'Oct-2026'),
('35', '2026-11-03', 'Nov-2026'),
('45', '2026-11-13', 'Nov-2026'),
('55', '2026-11-23', 'Nov-2026'),
('65', '2026-12-03', 'Dec-2026'),
('75', '2026-12-13', 'Dec-2026'),
('85', '2026-12-23', 'Dec-2026');

Fresh CSV: dt_table2.php
!wget -O dt_table2.csv https://www.plus2net.com/sql_tutorial/dt_table2.php

Date and time records

CREATE TABLE IF NOT EXISTS `dt_table_tm` (
  `event_id` INT NOT NULL,
  `tm` DATETIME NOT NULL,
  PRIMARY KEY (`event_id`),
  KEY `idx_dt_table_tm` (`tm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

Fresh CSV: dt_table_tm.php
!wget -O dt_table_tm.csv https://www.plus2net.com/sql_tutorial/dt_table_tm.php

Date Range Queries Date Exercises All Date & Time Functions

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Dynamic SQL test data for date and time queries

Daily records: 370 days before and after today

Previous 12 months to future 3 months

Date and time records

Subhendu Mohapatra