Re: any additional date_time functions?
| От | Richard Broersma Jr |
|---|---|
| Тема | Re: any additional date_time functions? |
| Дата | |
| Msg-id | 20060618152846.49958.qmail@web31806.mail.mud.yahoo.com обсуждение исходный текст |
| Ответ на | Re: any additional date_time functions? (Bruno Wolff III <bruno@wolff.to>) |
| Список | pgsql-sql |
> > 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, > You might be able to extract the time since the epoch and divide it by the > appropiate number of seconds (the length of your interval) and truncate > the result. This might have unexpected results for you when you span > daylight savings time changes. > > Another option is to not use timestamp, but rather just store an integer that > represents some number of your intervals offset from an epoch. Bruno, Thanks for the suggestions. I am going to "toy" around with them to see what I can get to work. Thanks for the help. Regards, Richard Broersma Jr.
В списке pgsql-sql по дате отправления: