PostgreSQLでUNIX時刻とTimestamp型の相互変換

select to_timestamp(1188831600);  →  "2007-09-04 00:00:00+09"

select extract(epoch from timestamp '2007-09-04');  →  1188831600

MySQLとかではどうなんだろ？