Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jack Parker — — source: Informix-list mailing list archive (1991-1998)
>
> I am trying to write a SQL statement that will look at 2 dates and determine
> the number of work days there are between them. I need to issue the SQL
> against many rows. If I can at least exclude the week-ends that would be
> great. The holidays, a bonus.... Does anyone have an answer?
>
Actually I just finished writing a chunk of code to do date arithmetic
handling weekends and holidays. It's in 4gl. Somebody else recently
sent me an SPL which does date arithmetic - I don't think it handled
holidays. Holler at me if you want a copy.
cheers
j.
_____________________________________________________________________________
Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA
jparker@hpbs3645.boi.hp.com
_____________________________________________________________________________
"I'm with the IRS, I'm here to help you"
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.