Re: [SQL] How to find number of seconds between 2 timestamps

2009-02-17 Thread Richard Huxton
Woody Woodring wrote: > I am trying to calculate a rate per second and am having trouble getting the > number of seconds between the two timestamps to use in the formula. > > overview=> select extract(epoch from interval '1 day'::interval); > date_part > --- > 86400 > (1 row) > >

[SQL] How to find number of seconds between 2 timestamps

2009-02-17 Thread Woody Woodring
I am trying to calculate a rate per second and am having trouble getting the number of seconds between the two timestamps to use in the formula. overview=> select extract(epoch from interval '1 day'::interval); date_part --- 86400 (1 row) overview=> select extract(epoch from inter