參考自 http://www.postgresql.org/docs/9.4/static/functions-datetime.html
--
EXTRACT(EPOCH FROM timestamptz '2015-07-01 00:00:00')
要抓出值的話前面加SELECT即可
SELECT EXTRACT(EPOCH FROM timestamptz '2015-07-01 00:00:00')
output: 1435680000
--
全站熱搜
參考自 http://www.postgresql.org/docs/9.4/static/functions-datetime.html
--
EXTRACT(EPOCH FROM timestamptz '2015-07-01 00:00:00')
要抓出值的話前面加SELECT即可
SELECT EXTRACT(EPOCH FROM timestamptz '2015-07-01 00:00:00')
output: 1435680000
--