Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the difference between two timestamp cells but in a special format in PostgreSQL - Mailing list pgsql-general

From litu16
Subject Re: Get the difference between two timestamp cells but in a special format in PostgreSQL
Date
Msg-id 1435288983880-5855215.post@n5.nabble.com
Whole thread Raw
In response to Re: Get the difference between two timestamp cells but in a special format in PostgreSQL  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Re: Get the difference between two timestamp cells but in a special format in PostgreSQL
List pgsql-general
Tree view 
Hi Adrian,

but I would like to get the time diff in this format

0years 0months 0days 00:00:00.000

not only hours, minutes, seconds.

is this possible???

Thanks Advanced.



--
View this message in context:
http://postgresql.nabble.com/Get-the-difference-between-two-timestamp-cells-but-in-a-special-format-in-PostgreSQL-tp5855074p5855215.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Functions, savepoints, autocommit = I am confused !
Next
From: Tim Smith
Date:
Subject: Re: Functions, savepoints, autocommit = I am confused !