View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001545||bugs.cacert.org||misc||public||2023-01-11 14:14||2023-02-08 22:35|
|Summary||0001545: Date Calculation issues throughout system|
|Description||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.
|Tags||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.