Skip to content

Instantly share code, notes, and snippets.

@strongant

strongant/postgresql进行查询时间差精确到秒取绝对值

Created May 20, 2016 06:25
Show Gist options
  • Save strongant/450f0ea7605874f93729d4aab9e778c1 to your computer and use it in GitHub Desktop.
Save strongant/450f0ea7605874f93729d4aab9e778c1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgresql进行查询时间差精确到秒取绝对值
select abs(extract (epoch from (age('2015-01-15 14:00:00','2015-01-15 14:00:00')))) from task where "taskId"='1';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment