Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How cast interval to minutes as number?
- From: Andreas <maps(dot)on(at)gmx(dot)net>
- To: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: How cast interval to minutes as number?
- Date: Sun, 25 Nov 2007 10:10:08 +0100
Andreas Kretschmer schrieb:
Andreas <maps(dot)on(at)gmx(dot)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
- References:
- How cast interval to minutes as number?
- From: Andreas
- Re: How cast interval to minutes as number?
- From: Andreas Kretschmer
- How cast interval to minutes as number?
- Prev by Date: Re: How cast interval to minutes as number?
- Next by Date: Re: A question of volatility
- Previous by thread: Re: How cast interval to minutes as number?
- Next by thread: Update field value
- Indexes: