> But this won't be the way you calculate the hours your customers have
> to pay for? ;-)
No, actually I was trying to figure out whether this kind of thing
could be done, could we really do that much number crunching of a
time value, within an SP. Rather then asking a question like how
much number crunching can be done within an SP using a time value, I
came up with a challenge.
> --
> Christian Kaas mailto:christian@...
> Client/Server/Internet/Multitier development
> http://www.ckaas.de
>
> > -----Ursprungliche Nachricht-----
> > Von: Paul Schmidt [mailto:paul@...]
> > Gesendet: Montag, 29. Januar 2001 17:54
> > An: IBObjects@yahoogroups.com
> > Betreff: [IBO] Time Fields
> >
> >
> >
> > Here is an interesting challenge to all.
> >
> > ITable that contains two time values, START_TIME and END_TIME, now I
> > want to calculate the number of hours difference between them, with
> > a slight twist, according to the following table:
> >
> > Minutes Start-Time End-Time
> >
> > < 15 0.0 0.25
> > 16 - 30 0.25 0.50
> > 31 - 45 0.50 0.75
> > 46 - 59 0.75 1.00
> >
> > So from 14:03 to 14:58, would be calculated as from 14.00 to 15.00
> > and return 1.00 hours.
> >
> > I know that the stored procedure for this, is going to win an ugly
> > contest, but I would like to be able to keep the actual physical
> > times, as well as the "rounded" times.
> >
Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com