Thread: Business Programming question
View Single Post
Old 07-25-2018, 03:40 AM  
Klen
 
Klen's Avatar
 
Industry Role:
Join Date: Aug 2006
Location: Little Vienna
Posts: 32,235
Quote:
Originally Posted by freecartoonporn View Post
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
Maybe two columns called "original time" and "updated time" ?
Klen is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote