Shulou(Shulou.com)06/03 Report--

-- timestamp to unix timestamp

Select now (), EXTRACT (EPOCH FROM TIMESTAMP WITH TIME ZONE 'now ()):: int as ext, extract (epoch FROM now ()):: int, CURRENT_TIMESTAMP,date_part (' epoch',CURRENT_TIMESTAMP):: int

-- unix timestamp to timestamp

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL' 1 second'

-- SELECT TIMESTAMP WITH TIME ZONE 'epoch' + extract (epoch FROM now ()) * INTERVAL' 1 second'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.