Postgres Pro
Downloads
Home   >   mailing lists

Adding seconds to a time - Mailing list pgsql-novice

From Rob Richardson
Subject Adding seconds to a time
Date
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D015548ED@server.rad-con.local
Whole thread Raw
List pgsql-novice
Tree view
I'm sure this has been answered so many times that the answers are buried somewhere in the millions of hits I get when I try to search for it.
 
I have a table whose rows contain the number of seconds since an event, and a foreign key into a second table that contains the actual time of the event.  How can I add the number of seconds to the event time to get the actual time a record was stored in the first table?
 
Thank you very much!
 
RobR
 
 

Robert D. Richardson
Product Engineer Software

RAD-CON, Inc.
TECHNOLOGY: Innovative & Proven
Phone : +1.440.871.5720 ... ext 123
Fax:  +1.440.871.2948
Website:  www.RAD-CON.com
E-mail:  rob.richardson@RAD-CON.com

 
Attachment

pgsql-novice by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: transaction is read-only error
Next
From: "Rob Richardson"
Date:
Subject: Re: Adding seconds to a time