mvosoughi Posted June 27, 2006 Share Posted June 27, 2006 I have a database and I need to retrive date for last 6 months from today's date. Basically it is a 6 months rollover. I tried to subtract old date from today's date but I was unsuccessful. Any ideas? thanks.. Quote Link to comment Share on other sites More sharing options...
Travis Estill Posted June 27, 2006 Share Posted June 27, 2006 Retrieve [i]data[/i] from the last 6 months? Assuming you're using timestamps, try this:[code]$query = "SELECT data FROM table WHERE time >= (".time()." - 15778463)";[/code] Quote Link to comment Share on other sites More sharing options...
Travis Estill Posted June 27, 2006 Share Posted June 27, 2006 [!--quoteo(post=388668:date=Jun 27 2006, 05:47 PM:name=melv)--][div class=\'quotetop\']QUOTE(melv @ Jun 27 2006, 05:47 PM) [snapback]388668[/snapback][/div][div class=\'quotemain\'][!--quotec--]I need to compare dates. But this way:I get a date from database. (yyyy-mm-dd format)I need to understand if this date is newer then "6 months" or not.What I need is get the current date,calculate the date 6 months ago,compare "the date from DB" & "the date 6 months ago from now"show the result.How will I do that please?[/quote]Oh, I see. Use strtotime() like this:[code]// Example date$date = "2006-06-04";$time = strtotime($date);$old = time() - 15778463; /* 6 months ago */if ($time <= $old) { // Date is at least 6 months old }else if ($time > $old) { // Date is less than 6 months old }[/code] Quote Link to comment Share on other sites More sharing options...
mvosoughi Posted June 28, 2006 Author Share Posted June 28, 2006 [!--quoteo(post=388674:date=Jun 28 2006, 12:37 AM:name=Travis Estill)--][div class=\'quotetop\']QUOTE(Travis Estill @ Jun 28 2006, 12:37 AM) [snapback]388674[/snapback][/div][div class=\'quotemain\'][!--quotec--]Oh, I see. Use strtotime() like this:[code]// Example date$date = "2006-06-04";$time = strtotime($date);$old = time() - 15778463; /* 6 months ago */if ($time <= $old) { // Date is at least 6 months old }else if ($time > $old) { // Date is less than 6 months old }[/code][/quote]Thanks guys.. worked alright ... cheers Quote Link to comment Share on other sites More sharing options...
yong Posted June 28, 2006 Share Posted June 28, 2006 i have a small question :This line: "$old = time() - 15778463; /* 6 months ago */"how calculate 15778463...think you ! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.