time arithmetic

[Tony Pack]

I want to calculate the duration of time for a timecard project. This
is a sample:

totaltime = (endtime1 - starttime1) + (endtime2 - starttime2)

totaltime is numeric, starttime1 & 2, endtime1 & 2 are ISO time values.
I am stumped so far, can anyone lend an example of the syntax?
thanks,
tony

[Nikolay A Mirin]

This seems OK. I mean the right part of the expression.
You'll probably need to convert when from strings or make up the each date,
the example of what you mean by ISO date, would help, but postgres should be
able to deal with it.
What number do you want in the left part?
the number of days, seconds, years?

"Tony Pack" <to***@psbiz.org> wrote in message
news:9J********************@comcast.com...

I want to calculate the duration of time for a timecard project. This is a
sample:

totaltime = (endtime1 - starttime1) + (endtime2 - starttime2)

totaltime is numeric, starttime1 & 2, endtime1 & 2 are ISO time values. I
am stumped so far, can anyone lend an example of the syntax?
thanks,
tony

[no-spam]

Hi Tony,

I'm guessing that you're trying to do these calculations in an SQL query?
How about this:

SELECT ( (time '10:00' - time '08:00') + (time '17:00' - time '15:00') )
AS TotalTime;

Hope this helps.

Cheers,
w.k.

On Sun, 6 Mar 2005, Tony Pack wrote:

I want to calculate the duration of time for a timecard project. This
is a sample:

totaltime = (endtime1 - starttime1) + (endtime2 - starttime2)

totaltime is numeric, starttime1 & 2, endtime1 & 2 are ISO time values.
I am stumped so far, can anyone lend an example of the syntax?
thanks,
tony