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 |
| Reporter | bdmc | Assigned To | bdmc | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | Default | OS | any | OS Version | any |
| 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. |
