| Subject | Re: [ib-support] Difference between two dates |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2002-11-21T12:57:27Z |
At 12:21 21.11.2002 +0000, you wrote:
this (could be a bit complicated) or find a UDF doing it for you (this
ought to exist, it should be a pretty common thing to do)
record which makes it useful whenever you only want one single result and
have nowhere to select it from.
Set
>Hi Svein,Oops, sorry - if so, I guess you either have to write a procedure that does
>
>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 ?
this (could be a bit complicated) or find a UDF doing it for you (this
ought to exist, it should be a pretty common thing to do)
>What is this "rdb$database" ?Just a system table in every IB or FB database that consists of exactly one
record which makes it useful whenever you only want one single result and
have nowhere to select it from.
Set