RE: Days(360)

FYI - Common accounting process, i.e. before computer were around to calculate the actual days on loan, etc. -----Original Message----- From: Edward Rosenthal [mailto:edrosenthal@home.com] Sent: Thursday, July 06, 2000 11:26 AM To: informix-list@iiug.org Subject: Re: Days(360) This is a multi-part message in MIME format. --------------8C2F3AF5DF00F608808291B8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit the function you describe does not sound all that accurate. you would be better off writing your own in sp, or if you use 4gl use the built in date and day functions... as you noted, if you had the use of a udr, you could use it inside an sql statement. Andris 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 --------------8C2F3AF5DF00F608808291B8 Content-Type: text/x-vcard; charset=us-ascii; name="edrosenthal.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Edward Rosenthal Content-Disposition: attachment; filename="edrosenthal.vcf" begin:vcard n:rosenthal;edward tel;cell:707 332 5558 tel;home:707 782 0766 tel;work:415 905 2431 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:erosenthal@mfi.com fn:edward rosenthal end:vcard --------------8C2F3AF5DF00F608808291B8--