Forum OpenACS Q&A: Re: how to find out the exact date of i.e. "1st monday of this month"

Collapse
7: Re: how to find out the exact date of i.e. "1st monday of this month" (response to 1)
Posted by Deds Castillo on 12/17/03 04:38 AM
David,

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.

Collapse
8: Re: how to find out the exact date of i.e. "1st monday of this month" (response to 7)
Posted by Dirk Gomez on 12/17/03 07:40 AM
Eh, I hope we remove date functions that hit the database step by step. AOLserver and/or TCL have date functions as well and using them means:

* 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.