Subject | RE: [firebird-support] How to do Time calculation |
---|---|
Author | Alan McDonald |
Post date | 2009-12-18T12:14:52Z |
> Next, the result of one particular date/time minus another does nothuh?
> result in a date or time, you should know that. It results in a
> "duration",
> which is stored in a format you would like, eg "integer" (depending on
> how precise you want it).
>
> Subtracting one "clockdatetime" from another (end-start) gives you the
> duration.
>
> With regards,
>
> Martijn Tonies
the result is a decimal. The integer part is number of days. The decimal
part is a fraction of one day.
1.5 = 24+12= 36 hours.
1.05892 = 25.41408 hours or 1 day 1 hour 24 minutes 51 secs
Alan