date_sub(now(),interval :timeLimit hour) code example

Example: mysql subtract month from timestamp

DATE_SUB((DATE_SUB(curdate(), INTERVAL 1 MONTH)), INTERVAL 4 DAY)