Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E031F2E3041 for ; Sat, 29 Dec 2007 06:52:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 59467-08 for ; Sat, 29 Dec 2007 06:52:43 -0400 (AST) Received: from web27208.mail.ukl.yahoo.com (web27208.mail.ukl.yahoo.com [217.146.182.98]) by postgresql.org (Postfix) with SMTP id F1AE32E3039 for ; Sat, 29 Dec 2007 06:52:46 -0400 (AST) Received: (qmail 67337 invoked by uid 60001); 29 Dec 2007 10:52:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=k+UIyuXUAyTF8l13aMrAeWNtg4cCwAEWv27oCKxJEhJiU9uWdx1tzM+jZr5zmq7FL/0DH3gkS/OLR4p2afuvwRwFaFtT8W/ZftirUQgBrnMHdmq9BG4EuC13o5DoywgGFwHr0TDf7PrpstiAKtiP3Ez2tvv1Ad6WjvMkkBv0beg=; X-YMail-OSG: MYNKeDcVM1kUUjDs1dcHgGh8QXFEpplIycWxa_4dU2RArmO7k.UeAQMAQiNHCbcLs9rGkKh8qHlYX2a2.EmYeu6V0c5N4xDz7pH1BV_PusEPNdSD7Aw_cluTlJs- Received: from [59.92.208.177] by web27208.mail.ukl.yahoo.com via HTTP; Sat, 29 Dec 2007 10:52:45 GMT Date: Sat, 29 Dec 2007 10:52:45 +0000 (GMT) From: Trilok Kumar Subject: sql query question ? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <238306.65674.qm@web27208.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.004 tagged_above=0 required=5 tests=BAYES_50=0.001, TRACKER_ID=2.003 X-Spam-Level: ** X-Archive-Number: 200712/150 X-Sequence-Number: 29842 Hi All, I have a table called vehicle_duty_cycle_summary vehicle_master_id | starting_odometer | ending_odometer | login_time | logout_time -------------------+-------------------+-----------------+----------------------------+---------------------------- 4 | 53379.00 | 53504.00 | 2006-12-19 16:19:16.584547 | 2006-12-20 07:12:57.716907 4 | 51310.00 | 51457.00 | 2006-12-05 16:04:51.585441 | 2006-12-06 07:18:10.251535 4 | 42411.00 | 42411.00 | 2006-09-14 16:03:49.541442 | 2006-09-15 08:24:41.308339 4 | 54012.00 | 54146.00 | 2006-12-25 16:14:31.313728 | 2006-12-26 07:05:55.82487 4 | 43071.00 | 43181.00 | 2006-09-21 11:24:43.466766 | 2006-09-22 07:10:09.362792 4 | 51208.00 | 51305.00 | 2006-12-04 16:14:14.600105 | 2006-12-05 08:03:38.139832 4 | 50235.00 | 50370.00 | 2006-11-27 15:55:48.866925 | 2006-11-28 07:27:25.898991 4 | 53231.00 | 53362.00 | 2006-12-18 16:06:42.764133 | 2006-12-19 07:06:03.450072 4 | 52656.00 | 52818.00 | 2006-12-13 16:03:47.189303 | 2006-12-14 07:59:11.463733 4 | 50801.00 | 50880.00 | 2006-12-02 16:03:55.666321 | 2006-12-03 06:53:21.433746 9 | 85360.00 | 85493.00 | 2007-06-10 07:17:12.330974 | 2007-06-10 22:11:04.422656 9 | 78009.00 | 78042.00 | 2007-03-12 17:53:18.794001 | 2007-03-12 20:42:39.439647 9 | 84529.00 | 84679.00 | 2007-06-01 06:42:09.306306 | 2007-06-01 20:35:54.317172 9 | 78058.00 | 78149.00 | 2007-03-13 10:08:48.696709 | 2007-03-13 21:50:31.136412 9 | 86506.00 | 86595.00 | 2007-06-21 09:28:40.504082 | 2007-06-21 23:15:41.862292 9 | 78155.00 | 78239.00 | 2007-03-14 09:32:58.512817 | 2007-03-14 20:58:24.36362 9 | 84894.00 | 85012.00 | 2007-06-04 07:59:00.896969 | 2007-06-04 18:42:13.791974 9 | 78435.00 | 78494.00 | 2007-03-16 07:48:23.626402 | 2007-03-16 21:39:09.479043 9 | 83992.00 | 84045.00 | 2007-05-25 07:25:20.462928 | 2007-05-25 21:23:43.697577 9 | 78506.00 | 78595.00 | 2007-03-17 08:01:06.003564 | 2007-03-17 19:48:32.383689 9 | 85493.00 | 85640.00 | 2007-06-11 06:58:03.052538 | 2007-06-11 22:56:13.134053 9 | 78279.00 | 78395.00 | 2007-03-15 08:00:58.198265 | 2007-03-15 21:39:00.052173 I would like to compute the following on this table. Idle time of vehicel=(ending_odometer reading of the previous day - starting_odometer reading of the present day) for every vehicle can anybody help me this issue. Thanks in advance. Trilok __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com