Postgres Pro
Downloads
Home   >   mailing lists

Re: Time difference without intervals - Mailing list pgsql-sql

From Tom Lane
Subject Re: Time difference without intervals
Date
Msg-id 27705.1036789865@sss.pgh.pa.us
Whole thread Raw
In response to Time difference without intervals  (Roberto Mello <rmello@cc.usu.edu>)
Responses Re: Time difference without intervals  (Bruno Wolff III <bruno@wolff.to>)
Re: Time difference without intervals  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Tree view 
Roberto Mello <rmello@cc.usu.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

pgsql-sql by date:

Previous
From: Robert Treat
Date:
Subject: Re: changing numeric into int
Next
From: Josh Berkus
Date:
Subject: Re: Permission on insert rules