Re: [SQL] date_trunc for 5 minutes intervals

2003-10-24 Thread Mathieu Arnold
+-Le 19/10/2003 23:38 +1000, email lists écrivait : | 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 achieve

Re: [SQL] date_trunc for 5 minutes intervals

2003-10-21 Thread email lists
Hi, Thanks for the several replies both on and off the list. To be more specific, I am wanting to aggregate data to a 5/10/15 min interval. Currently, I am aggregating data that falls in hour / day / month / year periods for both count() and sum(). The sql I am currently using is: SELECT count(

Re: [SQL] date_trunc for 5 minutes intervals

2003-10-20 Thread Richard Huxton
On Sunday 19 October 2003 14:38, email lists wrote: > 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 th

[SQL] date_trunc for 5 minutes intervals

2003-10-19 Thread email lists
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 ---(e