Re: funkiness with '1999-12-31 19:00:00-05'::timestamp with time zone - Mailing list pgsql-general

Josh Kupershmidt <schmiddy@gmail.com> writes:
> EXTRACT(epoch ...) was what I was looking for:

> SELECT EXTRACT(epoch FROM ts - '1999-12-31 19:00:00-05'::timestamptz)
> FROM timestamps_test LIMIT 5;
>        date_part
> -----------------------
>   1.4120666068199e-309
>   1.4154982781624e-309
>  1.41550281692099e-309
>  1.41591466059161e-309
>  1.41591524669472e-309
> (5 rows)

Wow.  You must have gotten those with the help of some arithmetic,
because timestamptzin would never have produced them.  I found out I can
do

regression=# select extract(epoch from ('2000-01-01 00:00:00'::timestamptz +
'0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001'::interval)
-'2000-01-01 00:00:00'); 
 date_part
-----------
    1e-209
(1 row)

but I wonder what it was you actually did.

            regards, tom lane