Subject Re: [firebird-support] Re: Hourly rate
Author Helen Borrie
At 10:29 AM 24/10/2005 +0100, Lester Caine wrote:
>Martijn Tonies wrote:
> >>I use TIME for hours and minutes and cast to TIME when I want to display
> >>a duration as hours and minutes. Days just being multiples of 24 hours (
> >>or what ever you want for the Martian clock ;) )
> >
> > But not a duration > 24 hours, I guess? As you are misusing the type... but
> > you know it ;)
>Yes a duration > 24 hours. It may be misusing the type, but I keep
>getting told - it's just numbers stored internally.
>Arithmetic on dates and times works nicely with days and fractions of
>days. better than where the times are stored as multiples of seconds :(

Care to share how you load e.g. '25:56:00.0000' into a TIME type without
getting a 335544334 error?