On Mon, Feb 27, 2023 at 8:26 PM PALAYRET Jacques
wrote:
> # PostgreSQL does not take into account the additional second (leap second)
> in some calendar days ; eg. 2016, 31 dec. :
> SELECT to_timestamp('20170102 10:11:12','mmdd hh24:mi:ss') -
> to_timestamp('20161230 00:00:00','mmdd hh24
zone '2022-03-26 12:00:00' ;
?column?
-
3 days 01:00:00
Regards
- Mail original -
De: "PALAYRET Jacques"
À: "Laurenz Albe"
Cc: pgsql-gene...@postgresql.org
Envoyé: Lundi 27 Février 2023 09:50:02
Objet: Re: Interval in hours but not in days
27;mmdd hh24:mi:ss') intervalle ;
intervalle
9 days
Regards
- Mail original -
De: "Laurenz Albe"
À: "PALAYRET Jacques" , pgsql-gene...@postgresql.org
Envoyé: Lundi 27 Février 2023 09:23:37
Objet: Re: Interval in hours but not in days Leap seco
On Mon, 2023-02-27 at 07:26 +, PALAYRET Jacques wrote:
> # An interval in " years months ... seconds " given in seconds by
> EXTRACT(EPOCH ...) transtyped into INTERVAL :
> SELECT (EXTRACT(EPOCH FROM ('3 years 2 months 1 day 10 hours 11 minutes 12
> seconds'::interval) ) || ' seconds')::inter
Hello,
# An interval in " years months ... seconds " given in seconds by EXTRACT(EPOCH
...) transtyped into INTERVAL :
SELECT (EXTRACT(EPOCH FROM ('3 years 2 months 1 day 10 hours 11 minutes 12
seconds'::interval) ) || ' seconds')::interval ;
interval
-
27772:11:12
# The same
