| Subject | Re: Update take hours to delete records :( |
|---|---|
| Author | nathanelrick |
| Post date | 2012-02-29T10:09:52Z |
> Update Session Setok, in fact we already do like this, but by 1 minute instead of by 5 minutes ... :(
> data=...
> Expiry_date= NOW + 15minutes
> where
> id=... and
> Date_expired > DATEADD(-5 minute to CAST('now' AS TIMESTAMP))