View Issue Details
|0001545: Date Calculation issues throughout system
|Date calculations reported in Bug 1544 also occur in other places in the various CACert systems.
For instance, date-dependent e-mail messages are not being sent.
Locate and correct these date calculations similarly to what was done for 1544.
|No tags attached.
I have examined all ( most ) of the SQL-related date calculations in the system, and, aside from the ones covered in bug 1544, they are all using the MySQL function unix_timestamp, which returns an integer number of seconds, related to the UNIX epoch. All other parts of those calculations are also integers.
Because of that, I do not feel that any of those calculations can produce wrong results in themselves.
As always, I am open to guidance as to areas to investigate further.