barkster Posted July 1, 2006 Share Posted July 1, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/13389-query-where-date-days/ Share on other sites More sharing options...
barkster Posted July 1, 2006 Author Share Posted July 1, 2006 Figured it out finallyWhere(Listings.EndDate + INTERVAL 60 DAY) < Now(); Quote Link to comment https://forums.phpfreaks.com/topic/13389-query-where-date-days/#findComment-51708 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.