jkakar@expressus.com 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