comparing stored timestamp with NOW()
[email protected] (Terion Miller)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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."