Re: [SQL] timestamp- milliseconds since epoch output

[Tom Lane]

[EMAIL PROTECTED] writes:
> I've tried using variations of to_char and to_timestamp but can't seem
> to get the timestamp as a value of milliseconds since the Epoch (Jan
> 1, 1970).

regression=# select date_part('epoch','2001-02-05 17:23:26.123456-08'::timestamp);
    date_part
------------------
 981422606.123456
(1 row)

Multiply by 1000 if you feel a strong urge to have it in milliseconds...

                        regards, tom lane