PostgreSQLでUNIX時刻とTimestamp型の相互変換
select to_timestamp(1188831600); → "2007-09-04 00:00:00+09"
select extract(epoch from timestamp '2007-09-04'); → 1188831600
MySQLとかではどうなんだろ?
select to_timestamp(1188831600); → "2007-09-04 00:00:00+09"
select extract(epoch from timestamp '2007-09-04'); → 1188831600
MySQLとかではどうなんだろ?