Postgres INTERVAL using value from table

by

Simply multiply the value with an interval:

select create_ts + num_of_day * interval '1' day 
from abc_company;

Since Postgres 9.4 this is easier done using the make_interval() function:

select create_ts + make_interval(days => num_of_day)
from abc_company;

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. Using an Alias column in the where clause in Postgresql
  3. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  4. Possible to perform cross-database queries with PostgreSQL?
  5. Reset auto increment counter in postgres
  6. Optimize query with OFFSET on large table
  7. GROUP BY and aggregate sequential numeric values
  8. How to concatenate columns in a Postgres SELECT?
  9. How to use (install) dblink in PostgreSQL?
  10. updating table rows in postgres using subquery
  11. How can I send email from PostgreSQL trigger?
  12. Find overlapping date ranges in PostgreSQL
  13. PostgreSQL multi INSERT…RETURNING with multiple columns
  14. How do you do date math that ignores the year?
  15. Postgres manually alter sequence
  16. What’s the proper index for querying structures in arrays in Postgres jsonb?
  17. “Operator does not exist: integer =?” when using Postgres
  18. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  19. Oracle equivalent of Postgres’ DISTINCT ON?
  20. Postgres sql insert query syntax error from phpPgAdmin
  21. postgresql generate sequence with no gap
  22. PostgreSQL: Case insensitive string comparison
  23. Combine two columns and add into one new column
  24. Bulk/batch update/upsert in PostgreSQL
  25. Grant privileges for a particular database in PostgreSQL
  26. Functions with variable number of input parameters
  27. Timestamp Difference In Hours for PostgreSQL
  28. SQL INSERT without specifying columns. What happens?
  29. How to create a new database with the hstore extension already installed?
  30. How to use a ring data structure in window functions

Leave a Comment