mysql timestamp manipulation

[Vivid Lust]

How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

 

from today

from this week

from this month

from the last 3 months

from the last 6 months

from this year

from 1 year ago

etc etc

 

?

 

Thanks

[smerny]

good solution found here: http://www.phpbuilder.com/board/showthread.php?t=10100466

 

## example start/end dates
$startdate = ( time() - 3587 );
$enddate = time();

## difference between the two in seconds
$time_period = ( $enddate - $startdate );

$days = 0;
$hours = 0;
$minutes = 0;
$seconds = 0;

$time_increments = array( 'Days' => 86400,
'Hours' => 3600,
'Minutes' => 60,
'Seconds' => 1 );

## will hold our values for ( day, minute, hour, seconds )
$time_span = array();

## cycle through time_increments
while( list( $key, $value ) = each( $time_increments )) {
$this_value = (int) ( $time_period / $value );
$time_period = ( $time_period % $value );

# save value
$time_span[$key] = $this_value;
}


## show results
while( list( $key, $value ) = each( $time_span )) {
print "$key $value<br>\n";
}

[Vivid Lust]

One last question,

 

How would I check if "2009-10-30 13:20:35" is older than a week? Thanks.

[Mchl]

SELECT "2009-10-30 13:20:35" < DATE_ADD(NOW(), INTERVAL -7 DAY)

[smerny]

With PHP? Check if the difference (subtraction) between the two dates is greater than 7 * 86400

[Vivid Lust]

Any how to check if its from today?

[Mchl]

SELECT DATE("2009-10-30 13:20:35") = CURDATE()