acs=# select extract(epoch from timestamp '2001-02-16 20:38:40-00'); date_part ----------- 982355920 (1 row)