Roberto Mello <[EMAIL PROTECTED]> writes:
> On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
>> I think your complaint is not that you get an interval, but that you
>> want it displayed differently. See to_char() ...
> It was not a complaint in any way. I apologize if I came across like
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
> Roberto Mello <[EMAIL PROTECTED]> writes:
> > Is there any way to make a timestamp difference operation not return an
> > interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> > or whatnot.
>
> I think your complain
On Fri, Nov 08, 2002 at 16:11:05 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Roberto Mello <[EMAIL PROTECTED]> writes:
> > Is there any way to make a timestamp difference operation not return an
> > interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> > or whatnot.
>
> I
Roberto Mello <[EMAIL PROTECTED]> writes:
> Is there any way to make a timestamp difference operation not return an
> interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> or whatnot.
I think your complaint is not that you get an interval, but that you
want it displayed diff
On Fri, Nov 08, 2002 at 11:20:02 -0700,
Roberto Mello <[EMAIL PROTECTED]> wrote:
>
> Is there any way to make a timestamp difference operation not return an
> interval? I'd like to get hours, minutes and seconds only, not the "1 day"
> or whatnot.
When you take a difference of two timestamps, y
I saw this question on another PG mailing list, and I don't know how to
answer. I've tried casting the interval to a timestamp, but that doesn't
seem to be supported in 7.2. Does anyone have an answer?
Is there any way to make a timestamp difference operation not return an
interval? I'd like to ge
