Re: How cast interval to minutes as number? - Mailing list pgsql-novice

From Andreas
Subject Re: How cast interval to minutes as number?
Date
Msg-id 47493BF0.6070006@gmx.net
Whole thread Raw
In response to Re: How cast interval to minutes as number?  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Andreas Kretschmer schrieb:
> Andreas <maps.on@gmx.net> schrieb:
>
>> This results in a column of type  interval.
>>  How would I get this interval converted into e.g. minutes.
>>
>
> Okay, lets assume i want to know how old is my daughter, in minutes:
> test=# select EXTRACT (EPOCH FROM  now() - '2007-07-28 09:15:00'::timestamp )::int/60;
>
Thanks and congratulations   ;-)

Andreas

pgsql-novice by date:

Previous
From: Andreas
Date:
Subject: Re: How cast interval to minutes as number?
Next
From: Dean Rasheed
Date:
Subject: Re: A question of volatility