Thread: Business Programming question
View Single Post
Old 07-25-2018, 02:56 AM  
freecartoonporn
Confirmed User
 
freecartoonporn's Avatar
 
Industry Role:
Join Date: Jan 2012
Location: NC
Posts: 7,683
i can think it like this way.

post creation time = X
post expiration timeframe (10 minutes, 1 hour, 1 day etc) = Y
post expiration time = Z

X + Y = Z

and my query would become,

if Z > current time {
remove records.
}

but Z gets changed everytime user edits post and changes expiration timeframe.

thanks
freecartoonporn is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote