0

I am trying to retrieve data from a column with integer values by getting the difference between the current_timestamp and the values in the column. This works in DB2 by simply stating the value as hour

TRANS_DATETIME > (CURRENT_TIMESTAMP - my_column_alias HOURS).

However using the same line in PostgreSQL returns the error below. Any ideas on how to modify query for PostgreSQL?

SQL Error [42883]: ERROR: operator does not exist: timestamp with time zone - integer¶
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.¶

Improve this question
1
  • Hi, and welcome to dba.se! Please tell us what server you are using - various functions vary (greatly) from RDBMS to RDBMS). Commented Nov 21, 2022 at 10:31

1 Answer 1

Reset to default
1

You can use make_interval() to construct an interval from a given number of hours that's stored in a column:

trans_datetime > current_timestamp - make_interval(hours => my_column)
Improve this answer
1
  • 1
    This worked perfectly. Thank you soo much Commented Nov 21, 2022 at 19:17

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.