Time Intervals
| От | Michael Richards |
|---|---|
| Тема | Time Intervals |
| Дата | |
| Msg-id | 3C6A9A0D.000015.04483@ns.interchange.ca обсуждение исходный текст |
| Ответы |
Re: Time Intervals
Re: Time Intervals |
| Список | pgsql-sql |
I've got a rather odd problem that I can't seem to solve easily with the given date manipulation functions. I've got an expiry timestamp and a renewal interval. If something has expired it gets renewed as the expiry + renewal * n Where n is the smallest number that will cause the calculation to result in the future. So if I've got a resource that is renewed by the hour and it expired last week then I need to add on enough hours so its new expiry will be up to 1 hour in the future. Only trouble is this renewal period can be anything from minutes to months and it may have expired up to 6 months ago. If I could convert the timestamp into a julian of some sort perhaps I could do the math that way. Any ideas? -Michael _________________________________________________________________ http://fastmail.ca/ - Fast Secure Web Email for Canadians
В списке pgsql-sql по дате отправления: