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