SQL, between, SUBTIME select the date and time in the desired range

How to make SQL request, sample for the last 2 days or 15 minutes.