Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5SHFNa39958 for ; Thu, 28 Jun 2001 13:15:23 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 78658 for ; Thu, 28 Jun 2001 10:15:21 -0700 From: "Josh Berkus" Subject: Re: Using DateDiff with Postgres To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Thu, 28 Jun 2001 10:15:21 -0700 Message-ID: In-Reply-To: <7a92561a.0106280301.6972d149@posting.google.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/455 X-Sequence-Number: 3758 Bruce, Tom, Etc: This question comes up so often. Can't we have a FAQ about it somewhere? Jeff, > Hi there. I was wondering if anyone can tell me the correct syntax > for > using DateDiff for postgrees. I'm using MI (or mi) for minute and I > keep getting attribute 'mi' not found. Datediff is not a SQL function. It is a MICROSOFT function, due to MS's poor implementation of data types. In PostgreSQL, you simply add and subtract interval values to datetime values: '2001-06-27 14:43:21'::DATETIME - '00:10:00'::INTERVAL = '2001-06-27 14:33:21'::DATETIME '2001-06-27 14:43:21'::DATETIME - '2001-06-27 14:33:21'::DATETIME = '00:10:00'::INTERVAL For more information, see "Functions and Operators" in the PostgreSQL online docs. -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco