Forum OpenACS Q&A: Re: how to find out the exact date of i.e. "1st monday of this month"
It only works because of the ports of the oracle functions. See my previous post on where those functions were defined.
The next_day function port for PG converts the weekday to int. So if you'd want to use 1, then I guess rewrite the function and support both a weekday and an int.
* hitting the database less frequently
* using less db handles
* less portability woes
If you are in a clustered environment you need to think about syncing times between the different machines. Oh, and whenever you stick data into the database then get the date+time from the database machine.