I use
$date = date("Y-m-d");
and in sql i use between max is = date("Y-m-d") min is = 6 days back
Is there a function that gives from date back $limit?
-
Sorry I don't understand exactly what you wantdan-lee– dan-lee2012-04-17 17:55:25 +00:00Commented Apr 17, 2012 at 17:55
-
i have date("Y-m-d") = 2012-04-12 what i want is that also 2012-04-05 is there a function that give me 6 days agosnnlankrdsm– snnlankrdsm2012-04-17 17:57:24 +00:00Commented Apr 17, 2012 at 17:57
-
1I think that what Dan is suggesting is that you edit your question to make it more clear. For example, use an example.ghoti– ghoti2012-04-17 17:59:12 +00:00Commented Apr 17, 2012 at 17:59
-
Yeah try to improve the question, although I think I understood it now. But SO serves as library where everyone can look up questions/answers.dan-lee– dan-lee2012-04-17 18:00:21 +00:00Commented Apr 17, 2012 at 18:00
Add a comment
|
3 Answers
In PHP, it could be done like this:
$date_first = date("Y-m-d"); //today's date or use some other date
$date_second = date("Y-m-d", strtotime(date("Y-m-d", strtotime($date_first)) . " -6 day")); //date before 6 days
EDIT
Based on Dan Lee's suggestion(see the comment below):
$date_before = date("Y-m-d", strtotime("-6 day"));
answered Apr 17, 2012 at 18:02
Akhilesh B Chandran
6,6087 gold badges33 silver badges59 bronze badges
3 Comments
dan-lee
strtotime('-6 days') is enough, but you would need to cover it with date()
Akhilesh B Chandran
@Dan Lee: Thanks for the suggestion. I have added that solution also(credit goes to you) :)
Akhilesh B Chandran
@Mert Metin: yeah sorry for that. I forgot to wrap it in a
date() to display a formatted date, instead of the timestamp. What you are getting is the timestamp. So, just pass it to the date() function along with the date format "Y-m-d".You can use MySQL only for this task.
Take DATE_SUB() to subtract from the current time:
SELECT * FROM table WHERE date BETWEEN DATE_SUB(NOW(), INTERVAL 6 DAY) AND CURDATE()
Comments
You could also use the OO variation of @AkhileshBChandran's answer:
$dt = new DateTime('-6 days');
$sixDaysAgo = $dt->format('Y-m-d');
