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