Re: comparing stored timestamp with NOW()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



$days = 7;
$now = date(Y-m-d);
$timestamp = /*your defined stamp */;
$query = "SELECT * from TABLE WHERE DATEDIFF('$timestamp', '$now')<=7";

I think that is the query you want? Unless I'm misreading the manual -
which is entirely possible.

Conversely you can just use DATEDIFF('$timestamp', DATE())<=7 as well.
The only thing you need to make sre is that your $timestamp is in
YYYY-MM-DD format.

On Tue, Feb 24, 2009 at 4:35 PM, Terion Miller <webdev.terion@xxxxxxxxx> wrote:
> Hi I need help formatting a sql statement that compares my stored timestamp
> $stamp with NOW()
> what I'm trying to do is generate a SELECT statement that pulls only records
> within 7 days of NOW()
> should i use
>
>  *SELECT DATEDIFF('stamp','NOW()')=7d; not sure how the difference
> part is syntaxed*
>
> Thanks
> Terion
>
> Happy Freecycling
> Free the List !!
> www.freecycle.org
> Over Moderation of Freecycle List Prevents Post Timeliness.
> ------------------------------------------------
> Twitter?
> http://twitter.com/terionmiller
> ------------------------------------------------
> Facebook:
> <a href="http://www.facebook.com/people/Terion-Miller/1542024891";
> title="Terion Miller's Facebook profile" target=_TOP><img src="
> http://badge.facebook.com/badge/1542024891.237.919247960.png"; border=0
> alt="Terion Miller's Facebook profile"></a>
> Vince Lombardi  - "Winning is habit. Unfortunately, so is losing."
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux