>Yes but in that case I will have to update the timestamp twice a year which is not something I would like to do.

Only once a year as it's either on side or the other. The problem here is when we go back.

>George Tasker has suggested to store UTC instead of the local time and I think that should solve my problem.

Yes, that would do.