Postgres Pro
Downloads
Home   >   mailing lists

how to get number of minutes? - Mailing list pgsql-general

From Chris Hoover
Subject how to get number of minutes?
Date
Msg-id 1d219a6f0610061222gfee862fo3883ca5659d6c07a@mail.gmail.com
Whole thread Raw
Responses Re: how to get number of minutes?  (Casey Duncan <casey@pandora.com>)
List pgsql-general
Tree view
If I subtract 2 timestamps, how do I get the results returned as the total number of minutes.

example

now() - (now()-'2 hours'::interval) = 2:00:00  -- I need the result returned as 120 minutes.

Thanks,

Chris

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DELETE eats up all memory and crashes box
Next
From: "Merlin Moncure"
Date:
Subject: Re: Storing images in PostgreSQL databases (again)