October 6th, 2004, 10:02 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
timestamp calculation?
good day to all.
i want to achieve list of rows for Average of encoder speed input.
i have this two table name cocv_2004 and with the ff columns;
-- cocv_id
-- personality_id
-- province_code
-- municipality_code
-- votes
-- db_user
-- timestamp
and
table name cc_encodersee with columns:
-- cc_encodersee_id
-- cc_id
-- polparty_id
-- db_user
-- timestamp
can anyone help me how to select out from this table of an avegare speed i refering from timestamp column? id like it to have a select only on columns cc_encodersee_id, cc_id, db_user, province_code, municipality_code, and timestamp(for average speed computation).
is there a way to compute time in sql queries function? can u give me with this example.? thanks in advance..
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
