Query Run
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
#SELECT NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); #(SELECT 89 * 24 *... 1 month ago
SELECT DATE_FORMAT(NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); (SELECT... 1 month ago
SELECT DATE_FORMAT(NOW() - (SELECT 89 * 24 * 3600), "%Y%m%d000000"); 1 month ago
SELECT DATE_FORMAT(NOW() - (89*24*3600), "%Y%m%d000000"); 1 month ago
SELECT DATE_FORMAT(NOW()-(89*24*3600), "%Y%m%d000000"); 1 month ago
SELECT DATE_FORMAT(NOW()-89, "%Y%m%d000000"); 1 month ago
SELECT DATE_FORMAT(NOW(), "%Y%m%d000000"); 1 month ago
select now(); SELECT DATE_FORMAT(NOW(), "%Y%M%D000000"); 1 month ago
select now() SELECT DATE_FORMAT(NOW(), "%Y%M%D000000"); 1 month ago
select now() 1 month ago