Postgres Pro
Downloads
Home   >   mailing lists

Re: interval - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: interval
Date
Msg-id 3C0BAFF9.17274634@fourpalms.org
Whole thread Raw
In response to interval  ("Yuri A. Kabaenkov" <sec@artofit.com>)
Responses Re: interval
List pgsql-general
Tree view 
>       How can i get time interval only in minutes or in seconds ?
>       For example i have '1 month 15 days' and i need these time in
>       minutes.

lockhart=# select extract(epoch from interval '1 month 15 days') / 60;
 ?column?
----------
    64800
(1 row)

                      - Thomas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should I use CAST?
Next
From: "Yuri A. Kabaenkov"
Date:
Subject: Re: interval