Jump to content

Archived

This topic is now archived and is closed to further replies.

mvosoughi

Date1 Minus Date1

Recommended Posts

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..

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
[!--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]

Share this post


Link to post
Share on other sites
[!--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

Share this post


Link to post
Share on other sites
i have a small question :

This line: "$old = time() - 15778463; /* 6 months ago */"

how calculate 15778463...

think you !

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.