Postgres Pro
Downloads
Home   >   mailing lists

date_trunc for 5 minutes intervals - Mailing list pgsql-sql

From email lists
Subject date_trunc for 5 minutes intervals
Date
Msg-id 035C9F7CE28601428BBB5B051C9F77F20766F4@orion.mackay.local
Whole thread Raw
Responses Re: date_trunc for 5 minutes intervals  (Richard Huxton <dev@archonet.com>)
Re: date_trunc for 5 minutes intervals  (Mathieu Arnold <mat@mat.cc>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Ian Barwick
Date:
Subject: Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen
Next
From: "George A.J"
Date:
Subject: Which is faster SQL or PL/PGSQL