date_trunc for 5 minutes intervals

From: email lists <lists(at)darrenmackay(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: date_trunc for 5 minutes intervals
Date: 2003-10-19 13:38:05
Message-ID: 035C9F7CE28601428BBB5B051C9F77F20766F4@orion.mackay.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adaś 2003-10-19 16:56:10 problem with sql
Previous Message Ian Barwick 2003-10-18 21:54:21 Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen