Forum OpenACS Q&A: Response to postgres-pgtcl.sql --> Is it meant to be commented out in load-data-model.sql?

Collapse
3: Response to postgres-pgtcl.sql --> Is it meant to be commented out in load-data-model.sql? (response to 1)
Posted by Don Baccus on 06/16/00 04:53 PM
Does anyone know the exact semantics of months_between in Oracle?

In other words, today's June 16th.

months_between(today, may 1) is one month.

Is months between(today, may 17th) one month or zero months? (i.e. does it truncate to the month then determine the interval?)

This routine's easy to implement in PL/pgSQL and I'll check one in if someone can tell me the exact semantics.