Re: Time difference without intervals

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Time difference without intervals
Date: 2002-11-08 21:11:05
Message-ID: 27705.1036789865@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Roberto Mello <rmello(at)cc(dot)usu(dot)edu> 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 differently. See to_char() ...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-11-09 01:35:01 Re: Permission on insert rules
Previous Message Robert Treat 2002-11-08 19:12:57 Re: changing numeric into int