Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5CHCSE59976 for ; Tue, 12 Jun 2001 13:12:28 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from smtp.dnet.net.id (engine9.dnet.net.id [202.148.1.21]) by postgresql.org (8.11.3/8.11.1) with SMTP id f587afE24824 for ; Fri, 8 Jun 2001 03:36:41 -0400 (EDT) (envelope-from nizomi@dnet.net.id) Received: (qmail 11169 invoked from network); 8 Jun 2001 14:20:38 +0700 Received: from nizomi.dnet.net.id (HELO ocemz) (nizomi@202.148.1.41) by engine9.dnet.net.id with SMTP; 8 Jun 2001 14:20:38 +0700 From: Tubagus Nizomi Date: Fri, 8 Jun 2001 14:36:46 +0700 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: pgsql-sql@postgresql.org Subject: Help datetime MIME-Version: 1.0 Message-Id: <01060814364602.08639@ocemz> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/181 X-Sequence-Number: 3420 i have problem in datetime my_table (start_date datetime,stop_date datetime); insert into my_table values ('Sun May 13 16:19:27 2001 JAVT','Sun May 13 14:06:13 2001 JAVT') select stop_date-start_date from my_table the result is "@ 2 hours 13 mins 14 secs" but i want result in minutes(integer) not interval have idea ?? plz help me thanks Nizomi