I can't tell what you want. Adding two times doesn't make sense. What is
3:15pm + 4:30am or 5:15 April 3 2003 + 4:27 June 14 1997. No such beast
exists. I suspect that one of your "times" is really an interval.
You can:
Subtract two times and get an interval
Add an interval to a time to get a time
Add two intervals to get an interval
What are you trying to do? It might help to tell us what the two columns
represent and what the result is supposed to represent.
Cheers,
Steve
On Monday 28 April 2003 3:17 pm, ed despard wrote:
> i have two collumns of type time, and i want to get the result of the
> two times added togeather. how do i go about doing this? i could use
> timestamps instead of times if necessary, but all the date/time
> functions seem to want to add intervals to things.
>
> thanks,
> ed
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster