Decrement days daily in membership site

Question

I have a database for membership site where users has a column day .This is number of days left until users membership expire.

Right now I run cron job daily at 12 AM to decrement day column by 1.

Is this the better solution or any other ideas available ? using date of registration and current today date.

Answer 1

Much better approach is to store membership expiration date and just compare with the current date.