| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Time difference without intervals |
| Date: | 2002-11-11 05:17:45 |
| Message-ID: | 20021111051745.GG23100@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
> 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() ...
It was not a complaint in any way. I apologize if I came across like that.
It was an honest question.
Thanks for the replies.
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
"Apple" (c) Copyright 1767, Sir Isaac Newton.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-11 05:22:16 | Re: Time difference without intervals |
| Previous Message | Tom Lane | 2002-11-10 13:50:24 | Re: [SQL] Parent table has not oid? |