I am working with the date_trunc() function with great success especially in
the group by clause
for aggregates.
However, it is limited to returning "WHOLE" time units. i.e. years, months,
days, hours, minutes,
seconds.
Are there any functions similar to date_trunc that can return variable
increments i.e.:
5, 10, or 15 minutes increments,
3, 4, 6 hour increments,
1, 2 weekly increments,
I imagine that the returned values would have to either be the "floor" or
"ceiling" of the actual
time stamps.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
