Skip site navigation (1) Skip section navigation (2)

How do I specify intervals in functions?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How do I specify intervals in functions?
Date: 2008-07-31 12:36:37
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D9A2261@server.rad-con.local (view raw or flat)
Thread:
Lists: pgsql-general
Greetings!
 
In the help file under date and time functions, I see that intervals can
be specified as "interval '3 hours' ".  In a PgAdmin SQL window, I can
enter "select interval '3 hours' ", and it will return me "03:00:00", as
expected.  I can also enter "select '3 hours'::interval", and get the
same result.  Yet neither syntax works inside a function.  
 
declare
     ThreeHours interval;
begin
     ThreeHours = interval '3 hours';  -- throws a syntax error
     ThreeHours = '3 hours'::interval; -- also throws a syntax error
end;
 
So how do I specify an interval in a function?
 
Specifically, I'm trying to do something like the following:
 
    if NewRevisionTime < PredictedEndTime - '08:00:00'::interval then
 
Since both of the shown forms give syntax errors, how do I subtract
eight hours from a time???
 
Thank you very much.
 
RobR, who posted this on the novice list but got no answers.
 

Responses

pgsql-general by date

Next:From: Michael GlaesemannDate: 2008-07-31 12:47:55
Subject: Re: How do I specify intervals in functions?
Previous:From: Reko TurjaDate: 2008-07-31 12:11:24
Subject: Re: Shared object "libpq.so.3" not found

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group