From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: extracting total amount of time from an interval |
Date: | 2010-07-01 12:17:25 |
Message-ID: | 20100701121723.GF26147@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to Andrew Geery :
> Is there a way to extract the total amount of time in a given unit from an
> interval? For example, I would like to know the total number of milliseconds
> in an interval.
>
> The expression
>
> select extract('seconds' from '5 minutes'::interval)
>
> returns the value of the seconds field (0) in the interval; not the total
> number of seconds in the interval. Is there a function like extract, but which
> extracts the value not *from* the given field, but *in* the given units (the
> opposite of the justify* functions)?
You can use extract:
test=*# select extract(epoch from '5 minutes'::interval);
date_part
-----------
300
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2010-07-01 13:10:01 | Re: PostgreSQL triggers |
Previous Message | Thom Brown | 2010-07-01 12:10:00 | Re: extracting total amount of time from an interval |