On 28/01/2025 00:05, Thomas Munro wrote: Thanks to you and all the others who took the trouble to reply,
I showed the bones of how you could do this in SQL here: https://www.postgresql.org/message-id/CA%2BhUKGLU9Don4YHnfdzn0eeWQsUu8GJDaLiUAefLLT6%3DmmeGoQ%40mail.gmail.com
The technical explanation is much appreciated - I'd gathered (more or less) as much from my searching and reading the leap second Wiki.
So, the situation is that, basically, leap seconds are "fudged" to use the technical term!
I asked the question with a view to having accurate TIMESTAMP differences - i.e. to the second. However, since everyone is fudging (incl. AFAICS Oracle and SQL Server), this means that accepting the status quo will just make my inaccuracies will be the same as everyone else's, ergo I'm golden!
At least that's one issue that I can safely ignore - I didn't fancy implementing this on my own.
Thanks again and rgs, E!
