How do I convert an interval into a number of hours with postgres?

by

Probably the easiest way is:

SELECT EXTRACT(epoch FROM my_interval)/3600

More Related Contents:

  1. PostgreSQL how to concat interval value ‘2 days’
  2. Daylight saving time and time zone best practices [closed]
  3. Determine Whether Two Date Ranges Overlap
  4. How do I convert a date/time string to a DateTime object in Dart?
  5. How to join two dataframes for which column values are within a certain range?
  6. PostgreSQL: running count of rows for a query ‘by minute’
  7. Kotlin DateTimeParseException
  8. Best way to store date/time in mongodb
  9. How to get the current time as datetime
  10. Can’t subtract offset-naive and offset-aware datetimes
  11. How do I determine the last day of the previous month using PostgreSQL?
  12. What’s the difference between ISO 8601 and RFC 3339 Date Formats?
  13. Time zone names with identical properties yield different result when applied to timestamp
  14. How do you do date math that ignores the year?
  15. Convert 12-hour date/time to 24-hour date/time
  16. Why are date/time values interpreted incorrectly when patching/saving?
  17. Parsing of Ordered Timestamps in Local Time (to UTC) While Observing Daylight Saving Time
  18. Pythonic way to combine datetime.date and datetime.time objects
  19. How to format a DateTime in PowerShell
  20. Aggregate Daily Data to Month/Year intervals
  21. Calculate the number of weekdays between 2 dates in R
  22. Best practices with saving datetime & timezone info in database when data is dependant on datetime
  23. Aggregating hourly data into daily aggregates
  24. Postgresql query between date ranges
  25. How to convert epoch to datetime redshift?
  26. Twig date difference
  27. Truncate timestamp to arbitrary intervals
  28. How to get timezone, Language and County Id in flutter by the location of device in flutter?
  29. Working with INTERVAL and CURDATE in MySQL
  30. Behind The Scenes: Core Data dates stored with 31 year offset?

Leave a Comment