RE: Days(360)

As I said in my other post, this is neither Andris' nor even M$'s fault -- most financial institutions use this in their calculations. It's largely why the time series datablade even exists. From: Watson Paul <Paul.Watson@fefc.ac.uk> > >So to make the maths easy Microsoft changes the calender > >Something like > >select end_date - start_date >from eric > >should work though > > > -----Original Message----- > > From: Andris [mailto:andris.shirons@dati.lv] > > Sent: Thursday, July 06, 2000 2:13 PM > > To: 'informix-list@iiug.org' > > Subject: Days(360) > > > > > > 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 > > > > >The contents of this e-mail are confidential to the ordinary user(s) of the >mail address(es) to which it was sent and may be legally privileged. >If you are not the intended recipient, any disclosure, copying, >distribution >or use of it, or any part of it, in any form whatsoever, and any actions >taken or omitted to be taken in reliance on it, is prohibited and may be >unlawful. > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com