Svein Erling wrote:

> Raigo, I'd rather say you made it pass your test than actually make it
> work. I cannot make sense of your computations. Let's say that I
> started working 12 April 2003 and quit 12 May 2004, that should be
> exactly 13 months. Here's your computation:

I think this is a nice example of the flexibility of Firebird over
MySQL. They have a PERIOD_DIFF function, which you give the value dates
required but it does not want days in the input. While we can adjust
things as required.

I had been trying to work out why there are so many apparently useful
functions in MySQL, but had missed the point that they store dates and
times as character strings. Working on simple numbers is so much eaiser,
and only takes up half the space. We can just 'DIFF' Timestamps and come
up with something usefull - they have to convert everything to numbers
first. But I have to keep something up my sleve for next week :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services