any additional date_time functions?

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема any additional date_time functions?
Дата
Msg-id 20060617200820.83165.qmail@web31805.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: any additional date_time functions?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-sql
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.


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Aaron Bono"
Дата:
Сообщение: Re: concurrency problem
Следующее
От: Ash Grove
Дата:
Сообщение: Re: concurrency problem