SELECT ADDDATE('0000-00-00 00:00:00', 0); SELECT ADDDATE('0000-00-00 00:00:00', 1); SELECT ADDTIME('0000-00-00 00:00:00', '00:00:00'); SELECT ADDTIME('0000-00-00 00:00:00', '01:02:03'); SELECT CONVERT_TZ('0000-00-00 00:00:00', '+02:00', '-02:00'); SELECT DATE('0000-00-00 00:00:00'); SELECT DATEDIFF('0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT DATEDIFF('0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT DATEDIFF('1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' MINUTE); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' MINUTE); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' HOUR); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' HOUR); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' DAY); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' DAY); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' WEEK); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' WEEK); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' MONTH); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' MONTH); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' QUARTER); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' QUARTER); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0' YEAR); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1' YEAR); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0.0' SECOND_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1.1' SECOND_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0.0' MINUTE_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1.1' MINUTE_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0:0' MINUTE_SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1:1' MINUTE_SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0.0' HOUR_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1.1' HOUR_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0:0:0' HOUR_SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1:1:1' HOUR_SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0:0' HOUR_MINUTE); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1:1' HOUR_MINUTE); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0.0' DAY_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1.1' DAY_MICROSECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0 0:0:0' DAY_SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1 1:1:1' DAY_SECOND); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0 0:0' DAY_MINUTE); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1 1:1' DAY_MINUTE); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0 0' DAY_HOUR); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1 1' DAY_HOUR); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '0-0' YEAR_MONTH); SELECT DATE_ADD('0000-00-00 00:00:00', INTERVAL '1-1' YEAR_MONTH); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' MINUTE); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' MINUTE); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' HOUR); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' HOUR); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' DAY); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' DAY); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' WEEK); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' WEEK); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' MONTH); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' MONTH); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' QUARTER); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' QUARTER); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0' YEAR); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1' YEAR); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0.0' SECOND_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1.1' SECOND_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0.0' MINUTE_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1.1' MINUTE_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0:0' MINUTE_SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1:1' MINUTE_SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0.0' HOUR_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1.1' HOUR_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0:0:0' HOUR_SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1:1:1' HOUR_SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0:0' HOUR_MINUTE); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1:1' HOUR_MINUTE); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0.0' DAY_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1.1' DAY_MICROSECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0 0:0:0' DAY_SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1 1:1:1' DAY_SECOND); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0 0:0' DAY_MINUTE); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1 1:1' DAY_MINUTE); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0 0' DAY_HOUR); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1 1' DAY_HOUR); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '0-0' YEAR_MONTH); SELECT DATE_SUB('0000-00-00 00:00:00', INTERVAL '1-1' YEAR_MONTH); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%a'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%b'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%c'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%D'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%d'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%e'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%f'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%H'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%h'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%I'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%i'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%j'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%k'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%l'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%M'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%m'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%p'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%r'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%S'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%s'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%T'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%U'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%u'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%V'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%v'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%W'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%w'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%X'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%x'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%Y'); SELECT DATE_FORMAT('0000-00-00 00:00:00', '%y'); SELECT DAY('0000-00-00 00:00:00'); SELECT DAYNAME('0000-00-00 00:00:00'); SELECT DAYOFMONTH('0000-00-00 00:00:00'); SELECT DAYOFWEEK('0000-00-00 00:00:00'); SELECT DAYOFYEAR('0000-00-00 00:00:00'); SELECT EXTRACT(MICROSECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(SECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(MINUTE FROM '0000-00-00 00:00:00'); SELECT EXTRACT(HOUR FROM '0000-00-00 00:00:00'); SELECT EXTRACT(DAY FROM '0000-00-00 00:00:00'); SELECT EXTRACT(WEEK FROM '0000-00-00 00:00:00'); SELECT EXTRACT(MONTH FROM '0000-00-00 00:00:00'); SELECT EXTRACT(QUARTER FROM '0000-00-00 00:00:00'); SELECT EXTRACT(YEAR FROM '0000-00-00 00:00:00'); SELECT EXTRACT(SECOND_MICROSECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(MINUTE_MICROSECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(MINUTE_SECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(HOUR_MICROSECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(HOUR_SECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(HOUR_MINUTE FROM '0000-00-00 00:00:00'); SELECT EXTRACT(DAY_MICROSECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(DAY_SECOND FROM '0000-00-00 00:00:00'); SELECT EXTRACT(DAY_MINUTE FROM '0000-00-00 00:00:00'); SELECT EXTRACT(DAY_HOUR FROM '0000-00-00 00:00:00'); SELECT EXTRACT(YEAR_MONTH FROM '0000-00-00 00:00:00'); SELECT HOUR('0000-00-00 00:00:00'); SELECT LAST_DAY('0000-00-00 00:00:00'); SELECT MICROSECOND('0000-00-00 00:00:00'); SELECT MINUTE('0000-00-00 00:00:00'); SELECT MONTH('0000-00-00 00:00:00'); SELECT MONTHNAME('0000-00-00 00:00:00'); SELECT QUARTER('0000-00-00 00:00:00'); SELECT SECOND('0000-00-00 00:00:00'); SELECT STR_TO_DATE('0000-00-00 00:00:00', '%Y-%m-%d %H:%M:%S'); SELECT SUBDATE('0000-00-00 00:00:00', 0); SELECT SUBDATE('0000-00-00 00:00:00', 1); SELECT SUBTIME('0000-00-00 00:00:00', '00:00:00'); SELECT SUBTIME('0000-00-00 00:00:00', '01:02:03'); SELECT TIME('0000-00-00 00:00:00'); SELECT TIMEDIFF('0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMEDIFF('0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMEDIFF('1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMP('0000-00-00 00:00:00'); SELECT TIMESTAMP('0000-00-00 00:00:00', '00:00:00'); SELECT TIMESTAMP('0000-00-00 00:00:00', '01:02:03'); SELECT TIMESTAMPADD(FRAC_SECOND, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(FRAC_SECOND, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(SECOND, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(SECOND, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(MINUTE, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(MINUTE, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(HOUR, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(HOUR, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(DAY, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(DAY, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(WEEK, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(WEEK, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(MONTH, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(MONTH, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(QUARTER, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(QUARTER, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(YEAR, 0, '0000-00-00 00:00:00'); SELECT TIMESTAMPADD(YEAR, 1, '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(FRAC_SECOND, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(FRAC_SECOND, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(FRAC_SECOND, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(SECOND, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(SECOND, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(SECOND, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(MINUTE, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(MINUTE, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(MINUTE, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(HOUR, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(HOUR, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(HOUR, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(DAY, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(DAY, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(DAY, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(WEEK, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(WEEK, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(WEEK, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(MONTH, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(MONTH, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(MONTH, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(QUARTER, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(QUARTER, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(QUARTER, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(YEAR, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); SELECT TIMESTAMPDIFF(YEAR, '0000-00-00 00:00:00', '1981-02-03 04:05:06'); SELECT TIMESTAMPDIFF(YEAR, '1981-02-03 04:05:06', '0000-00-00 00:00:00'); SELECT TO_DAYS('0000-00-00 00:00:00'); SELECT UNIX_TIMESTAMP('0000-00-00 00:00:00'); SELECT WEEK('0000-00-00 00:00:00', 0); SELECT WEEK('0000-00-00 00:00:00', 1); SELECT WEEK('0000-00-00 00:00:00', 2); SELECT WEEK('0000-00-00 00:00:00', 3); SELECT WEEK('0000-00-00 00:00:00', 4); SELECT WEEK('0000-00-00 00:00:00', 5); SELECT WEEK('0000-00-00 00:00:00', 6); SELECT WEEK('0000-00-00 00:00:00', 7); SELECT WEEKDAY('0000-00-00 00:00:00'); SELECT WEEKOFYEAR('0000-00-00 00:00:00'); SELECT YEAR('0000-00-00 00:00:00'); SELECT YEARWEEK('0000-00-00 00:00:00'); SELECT YEARWEEK('0000-00-00 00:00:00', 0); SELECT YEARWEEK('0000-00-00 00:00:00', 1); SELECT YEARWEEK('0000-00-00 00:00:00', 2); SELECT YEARWEEK('0000-00-00 00:00:00', 3); SELECT YEARWEEK('0000-00-00 00:00:00', 4); SELECT YEARWEEK('0000-00-00 00:00:00', 5); SELECT YEARWEEK('0000-00-00 00:00:00', 6); SELECT YEARWEEK('0000-00-00 00:00:00', 7);