the 3rd of June to the 28th September...
is that July, August = 2 months
3-30 June = 27 days
1-28 Sept = 28 days
therefore 2 months 56 days????
-----Original Message-----
From: helton_o [mailto:helton_o@...]
Sent: Thursday, 21 November 2002 23:21
To: ib-support
Subject: Re: [ib-support] Difference between two dates


Hi Svein,

Thanks for your help. I need the result in years, months and days, so, how
can I convert the resulting difference in days to years, months and days ?

What is this "rdb$database" ?

Thanks,

Helton

>Helton,
>this is either simpler than you think or your question more >complicated
>than I think - subtracting two dates from eachother results in the
>difference in days. E.g.
>
>Select '21.11.2002' - '01.11.2002' as NoOfDays
>from rdb$database
>
>should return 20.

At 11:31 21.11.2002 +0000, you wrote:

>Hi,
>
>Does anyone has, or knows where can I find, a procedure which calculates
>the difference between two dates giving the result in days, months and

years ?

>
>Thanks,
>
>Helton

Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]