Adding a stored number of minutes to a stored time - Mailing list pgsql-novice

From Rob Richardson
Subject Adding a stored number of minutes to a stored time
Date
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D017CC3B7@server.rad-con.local
Whole thread Raw
Responses Re: Adding a stored number of minutes to a stored time  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-novice

Greetings!

 

All of the examples I can find for adding a number of minutes to a timestamp show the number of minutes being hard-coded in the query.  I have a table that has a column containing a starting time and another column containing the number of minutes until the process will be finished.  I want to add the starting time and the number of minutes to calculate the finish time.  How do I convert the minutes column from an int4 to an interval?  Or is there a different way I should do that?

 

Thanks very much!

 

RobR

pgsql-novice by date:

Previous
From: Marc-André Laverdière
Date:
Subject: SSL root.crt not loading
Next
From: Michael Glaesemann
Date:
Subject: Re: Adding a stored number of minutes to a stored time