> On 20 Mar 2024, at 00:24, Cary Huang <cary.hu...@highgo.ca> wrote:
> but it seems to me that many of the timestamp related functions still consider > timestamp or timestampTz as "double values with units of seconds" though. The issue here is that postgres use a different epoch from the unix epoch, so any dates calcuated based on the unix epoch need to be adjusted. I've hacked this up in the attached v11 using overflow-safe integer mul/add as proposed by Jacob upthread (we really shouldn't risk overflowing an int64 here but there is no harm in using belts and suspenders here as a defensive measure). The attached v11 is what I propose we go ahead with unless there further comments on this. -- Daniel Gustafsson
v11-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch
Description: Binary data