mysql select closest date from today, MySQL

Language: Layout:

-- ----------------------------
-- Table structure for closest_date_table
-- ----------------------------
DROP TABLE IF EXISTS `closest_date_table`;
CREATE TABLE `closest_date_table` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of closest_date_table
-- ----------------------------
INSERT INTO `closest_date_table` VALUES ('1', '2017-01-02 20:59:00');
INSERT INTO `closest_date_table` VALUES ('2', '2017-01-04 10:00:00');
INSERT INTO `closest_date_table` VALUES ('3', '2017-01-04 11:00:00');
INSERT INTO `closest_date_table` VALUES ('4', '2017-01-09 17:20:00');

SELECT
    *
FROM
    closest_date_table
WHERE
    date(`date`) = (
        SELECT
            min(date(`date`))
        FROM
            closest_date_table
        WHERE
            date(`date`) > date('2017-01-03')
    );
    
    
SELECT
    *
FROM
    closest_date_table
WHERE
    date(`date`) = (
        SELECT
            min(date(`date`))
        FROM
            closest_date_table
        WHERE
            date(`date`) > date('2017-01-05')
    );


absolute service time: 0,33 sec