Skip site navigation (1) Skip section navigation (2)

How cast interval to minutes as number?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: ListaPostgre <pgsql-novice(at)postgresql(dot)org>
Subject: How cast interval to minutes as number?
Date: 2007-11-25 07:43:22
Message-ID: 4749279A.8010805@gmx.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I have a column with timestamps  --> some_ts  .
I'd like to calculate the amount of time between this timestamp and NOW().

select   some_ts - NOW()   from some_table;

This results in a column of type  interval.
 
How would I get this interval converted into e.g. minutes.
I need the whole value converted not just the 0-59 minutes part.
Like  a difference of exactly 1 day = 24*60 minutes rather than 0 
minutes if I just take the minute-part.

Seconds would be fine, too.


select EXTRACT (EPOCH FROM INTERVAL some_ts - NOW()) from ....

gets me a syntax error

Help?

Regards
Andreas

Responses

pgsql-novice by date

Next:From: Maximilian TyrtaniaDate: 2007-11-25 08:32:12
Subject: Re: How cast interval to minutes as number?
Previous:From: Michael GlaesemannDate: 2007-11-24 14:20:02
Subject: Re: A question of volatility

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group