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