Add integer value from another column to date in postgresql [duplicate]

Question

I want to add the value of another colum (which is an an integer representing miliseconds) to a date value in an update query. I tried what this answer suggests but I can't find a way to not hardcode the value in the query but instead read it from the other column.

The two relevant fields are:

ScheduledExecuteDate: DATE(6)
RecurringInterval: INTEGER representing the number of miliseconds to add to the date

My query looks something like this:

UPDATE "Tasks" SET 
"ScheduledExecuteDate"="ScheduledExecuteDate" + interval ("RecurringInterval" / 1000) second 
WHERE "id" = 62

I've also tried 'second'. In both cases it throws an syntax error "at or near second" Also note that I have to wrap the column names in quotes since they are case sensitive.

I also tried

"scheduledExecuteDate"=DATE_ADD("scheduledExecuteDate", interval ("Tasks"."recurringInterval" / 1000) seconds)

like answered here

user330315 · Accepted Answer · 2022-02-09 09:12:46Z

1

You can use make_interval() passing fractional seconds:

UPDATE "Tasks" 
  SET "ScheduledExecuteDate" = "ScheduledExecuteDate" 
                               + make_interval(secs => "RecurringInterval"::double precision / 1000) second 
WHERE "id" = 62

answered Feb 9, 2022 at 9:12

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add integer value from another column to date in postgresql [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related