Guest User

Untitled

a guest
Dec 10th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT
  2. id AS dive_id,
  3. to_char(start_time, 'YYYY:MM:DD HH:MM') AS start_time,
  4. to_char(end_time, 'YYYY:MM:DD HH:MM') AS end_time,
  5. (extract('days' FROM NOW()) * 24) + extract('hour' FROM now()-start_time) || ':' || extract('minute' FROM now()-start_time) || ':' || extract('second' FROM date_trunc('second', now()-start_time))
  6. AS
  7. elapsed_time
  8. FROM
  9. checklist
  10. ORDER BY
  11. id desc
  12. LIMIT 1
Add Comment
Please, Sign In to add comment