Jump to content


Photo

Query where date + days?


  • Please log in to reply
1 reply to this topic

#1 barkster

barkster
  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts

Posted 01 July 2006 - 03:11 PM

I have a datefield(timestamp) that I want to query to see if it has expired.  Is to possible to a select query WHERE datefield + 60 days < now()?  Thanks

#2 barkster

barkster
  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts

Posted 01 July 2006 - 03:35 PM

Figured it out finally

Where
(Listings.EndDate + INTERVAL 60 DAY) < Now();




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users