WebOct 13, 2015 · I would suggest just putting the following SQL statement in a cron job (like a single .php file), and the rest will be handled by itself. DELETE FROM wp_posts WHERE post_date < DATE_SUB (NOW (), INTERVAL 30 DAY); Here's a good rundown on using cron to automatically do these kinds of this for you Update WebAug 19, 2024 · Example : DATE_SUB () function with plus (+) operator. The following statement will return a datetime after adding 1 HOUR with 2008-05-15. This example …
DATE_SUB() Function in MySQL - GeeksforGeeks
WebMar 16, 2015 · CREATE EVENT purgebinlogs ON SCHEDULE EVERY 1 WEEK STARTS CONCAT (CURRENT_DATE + INTERVAL 7 - WEEKDAY (CURRENT_DATE) DAY,' 01:00:00') DO PURGE BINARY LOGS BEFORE DATE_SUB ( NOW ( ), INTERVAL 7 DAY); It should run every monday at 01:00. However if i query mysql.event table i get the … WebMar 6, 2024 · 1 Answer. You should use from_unixtime function to convert the date either to the where condition and to see a readable date format: SELECT from_unixtime (`timestamp`) FROM table WHERE from_unixtime (`timestamp`) > date_sub (now (), interval 7 day); March, 05 2024 05:58:26 March, 03 2024 21:31:16 March, 03 2024 … reagan muffler center
date_sub ok with mysql, ko with postgresql - Stack Overflow
WebDec 3, 2024 · DATE_SUB(date, INTERVAL value addunit) Parameter: This function accepts two parameters which are illustrated below : date – Specified date to be modified value addunit – Here the value is date or time interval to subtract. This value can be both positive and negative. And here the addunit is the type of interval to subtract such as … WebIn this case, the argument date is the output of the NOW () function, and the interval is 30 days. The function subtracts the 30 days from the current date and time. You may play around with the DATE_SUB () function to get values in the other intervals such as a month, hour, minute, second, year, etc. Example #3 WebThe number of days to subtract may also be expressed in a variable as shown below. SET today = %date. SETNUM x = 14. DATESUB today x. DISPLAY today. Related command … how to take string input in scanner class