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
I have a query that returns
?column?
-
6 days 01:56:14
(1 row)
How can I get it as total number of hours?
Instead of days and hours, I need hours only (all in all, so 24hours * 6
days + 01:56:14)
Can you help me please? Thanks
---(end of bro
i want to calculate the session time. my query is thisselect now()
- '2001-05-19 12:09:00+5;it gives the difference in date and difference
in time separately. if thecurrent time is greater than the second time then
it gives simply theirdifference but i want to calcutate the session time
f
