Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding seconds to a time - Mailing list pgsql-novice

From Rob Richardson
Subject Re: Adding seconds to a time
Date
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D015548EE@server.rad-con.local
Whole thread Raw
In response to Adding seconds to a time  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Responses Re: Adding seconds to a time  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-novice
Tree view
And, of course, as soon as I post the question I find the answer, through a more intelligent search:
 
Multiply the number by a standard interval: 
    select N * '1 second'::interval
 
RobR
 

pgsql-novice by date:

Previous
From: "Rob Richardson"
Date:
Subject: Adding seconds to a time
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: Adding seconds to a time