Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

2025-01-28 Thread Nem Tudom
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

Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

2025-01-27 Thread Nem Tudom
Hi all, I'm having trouble understanding matters related to TIMESTAMP(TZ)-s and leap seconds - my machine runs on UTC so as to remove any issues related to the zones. From here: https://en.wikipedia.org/wiki/Leap_second, There have been 27 leap seconds added to UTC since 1972. But, whe