Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA20987
	for <pgsql-sql@postgreSQL.org>; Tue, 17 Aug 1999 09:35:09 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id JAA15496;
	Tue, 17 Aug 1999 09:34:21 -0400 (EDT)
To: "Pham, Thinh" <tpham@mail.priority.net>
cc: "'pgsql-sql@postgreSQL.org'" <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] datediff function 
In-reply-to: Your message of Tue, 17 Aug 1999 08:18:55 -0500
	<551413BBBB03D111BF880060B01AACCE139F34@home.priority.net>
Date: Tue, 17 Aug 1999 09:34:21 -0400
Message-ID: <15494.934896861@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"Pham, Thinh" <tpham@mail.priority.net> writes:
> What happen if i just want to compare using minute only or hour only instead
> of day? Is there a function to do that or is postgres only work in day?

See date_part().

			regards, tom lane