Re: Days(360)
At 09:19 AM 07/06/2000, mr_tricky wrote: >Only Micro$oft could come up with the concept of a 360 day year. >I guess it's the new Windoze Year TM and will become standard >across all software :-) This is not so new. The calendar of 360 days is used extensively in the financial industry so that each month has exactly the same number of days. This has to do with the way interest and bond payments and the like are calculated. Its one of the things that Dr. Stonebraker used to show why extensibility matters. The ANSI SQL date-time arithmetic doesn't work for the financial community. So the real question is how many other calendars will MS choose to include in their product. In IDS.2000, I can define as many different calendars as required: Jewish, Chinese, etc.. MS has finally realized that SQL Server can't compete in some markets because certain require functions are missing. Just my $.02, Dick > >Anyway ranting aside, SQL can do the trick: > >SELECT (DATE('01/03/2000') - DATE('01/02/2000')) UNITS DAY >FROM systables >WHERE tabid = 1 > >should do what you want. It even works out leap years correctly! >Put it in a SP accepting two dates and returnng one integer and >Robert is your Mothers Brother > >Cheers > >Tricky > >Andris <andris.shirons@dati.lv> wrote: >> >>Hi, all. >> >>There's built-in function in Microsoft products for time >calculation, >>where year is regarded as having 360 days and month has 30 days. >>As parameters it receives start of the period (date), end of >>the period (date) and it it returns number of days. >> >>AS I know, Informix doesn't have such function, but maybe >somebody >>knows, where to get such function or SP? >> >>Thanks in advance! >>Andris >> >> >> > > > >----------------------------------------------------------- > >Got questions? Get answers over the phone at Keen.com. >Up to 100 minutes free! >http://www.keen.com > Dick Snoke dsnoke@informix.com Partner Engineering 770-395-2308 (office) Informix Software 770-886-7301 (home office) 5 Concourse Parkway Suite 1500 Atlanta, Georgia 30328
In article <8k2gkr$h67$1@news.xmission.com>, Dick Snoke <dsnoke@informix.com> wrote: > > At 09:19 AM 07/06/2000, mr_tricky wrote: > >Only Micro$oft could come up with the concept of a 360 day year. > >I guess it's the new Windoze Year TM and will become standard > >across all software :-) > > This is not so new. The calendar of 360 days is used extensively in the > financial industry so that each month has exactly the same number of days. > This has to do with the way interest and bond payments and the like are > calculated. Its one of the things that Dr. Stonebraker used to show why > extensibility matters. The ANSI SQL date-time arithmetic doesn't work for > the financial community. So the real question is how many other calendars > will MS choose to include in their product. In IDS.2000, I can define as > many different calendars as required: Jewish, Chinese, etc.. > > MS has finally realized that SQL Server can't compete in some markets > because certain require functions are missing. > > Just my $.02, > Dick > Hey Dick, why don't you give that $.02 to the Informix stock price or better yet their marketing campaign, they both could use it about now. You mentioned MS SQL Server not competing in some markets, lately I have been trying to figure out in what markets Informix is trying to compete. Matur Suksema > > > >Anyway ranting aside, SQL can do the trick: > > > >SELECT (DATE('01/03/2000') - DATE('01/02/2000')) UNITS DAY > >FROM systables > >WHERE tabid = 1 > > > >should do what you want. It even works out leap years correctly! > >Put it in a SP accepting two dates and returnng one integer and > >Robert is your Mothers Brother > > > >Cheers > > > >Tricky > > > >Andris <andris.shirons@dati.lv> wrote: > >> > >>Hi, all. > >> > >>There's built-in function in Microsoft products for time > >calculation, > >>where year is regarded as having 360 days and month has 30 days. > >>As parameters it receives start of the period (date), end of > >>the period (date) and it it returns number of days. > >> > >>AS I know, Informix doesn't have such function, but maybe > >somebody > >>knows, where to get such function or SP? > >> > >>Thanks in advance! > >>Andris > >> > >> > >> > > > > > > > >----------------------------------------------------------- > > > >Got questions? Get answers over the phone at Keen.com. > >Up to 100 minutes free! > >http://www.keen.com > > > > Dick Snoke dsnoke@informix.com > Partner Engineering 770-395-2308 (office) > Informix Software 770-886-7301 (home office) > 5 Concourse Parkway > Suite 1500 > Atlanta, Georgia 30328 > Sent via Deja.com http://www.deja.com/ Before you buy.