rhubbell wrote:
(posted on novice too, no idea what difference is between lists)
I have been trying to do this and have been unsuccessful so far.
I have a table:
perf:
timestamp = timestamp with time zone
timeelapsed = numeric
bobble = text
timeelapsed records are the time elapsed metric in seconds.
e.g. 0.350058078765869
Typical scenario is that I'll have multiple entries where timeelapsed
is greater than some value and will be greater than that value for
some time interval.
I want to find the length of those intervals.
select timestamp, timeelapsed, bobble from perf where bobble like "pokerflat"
and timeelapsed > 0.4;
The records returned by that query will have an oldest and newest timestamp for
which I would like to calculate the interval.
I'm not real clear on what you are asking here with oldest and newest
timestamps and getting the interval, please clarify
I found lots of examples of doing arithmetic on timestamps but I never saw
any extracting data from a table. All the examples I found were using now()
or current_date + 3 or the like.
Just substitute current_date or now() appears in the examples with the
column name
Do aggregate function work on time data?
For date time function go here
http://www.postgresql.org/docs/8.3/static/functions-datetime.html
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
