X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A33F3D1B509 for ; Sun, 19 Oct 2003 20:09:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51512-06 for ; Sun, 19 Oct 2003 17:08:30 -0300 (ADT) Received: from mta03ps.bigpond.com (mta03ps.bigpond.com [144.135.25.157]) by svr1.postgresql.org (Postfix) with ESMTP id E9067D1B52D for ; Sun, 19 Oct 2003 17:08:22 -0300 (ADT) Received: from centauri.darrenmackay.com ([144.135.25.78]) by mta03ps.email.bigpond.com (iPlanet Messaging Server 5.2 HotFix 1.14 (built Mar 18 2003)) with SMTP id <0HN0004A7T9V8U@mta03ps.email.bigpond.com> for pgsql-sql@postgresql.org; Mon, 20 Oct 2003 06:08:20 +1000 (EST) Received: from cpe-203-45-149-167.qld.bigpond.net.au ([203.45.149.167]) by psmam04bpa.bigpond.com(MAM REL_3_3_2d 98/5582029); Mon, 20 Oct 2003 06:08:19 +0000 Received: from [192.168.1.203] (helo=orion.mackay.local) by centauri.darrenmackay.com with esmtp (Exim 4.12) id 1ABJqd-0000d9-00 for pgsql-sql@postgresql.org; Mon, 20 Oct 2003 06:08:19 +1000 Received: from orion.mackay.local (unverified) by orion.mackay.local (Content Technologies SMTPRS 4.2.5) with ESMTP id for ; Sun, 19 Oct 2003 23:38:05 +1000 Date: Sun, 19 Oct 2003 23:38:05 +1000 From: email lists Subject: date_trunc for 5 minutes intervals To: pgsql-sql@postgresql.org Message-id: <035C9F7CE28601428BBB5B051C9F77F20766F4@orion.mackay.local> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6249.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-class: urn:content-classes:message Thread-topic: date_trunc for 5 minutes intervals Thread-index: AcOVPXMp6MzQvnsjQrmx/bjLjA15FABCF3sw X-MS-Has-Attach: X-MS-TNEF-Correlator: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/220 X-Sequence-Number: 15620 Hi All, I am wanting to perform the equivalent of date_trunc to 5/10/15 minute intervals. As this does mnot seem to be natively supported by date_trunc, can anyone point me in the right direction to possible write the SQL ro acheive the desired outcome? Tia, Darren