Subject RE: [firebird-support] How to do Time calculation Vishal Tiwari 2009-12-18T14:34:39Z
huh?
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

Total time period means total hours and minuts worked for all employees for each day is needed.

Regards

Vishal Tiwari...

--- On Fri, 18/12/09, Alan McDonald <alan@...> wrote:

From: Alan McDonald <alan@...>
Subject: RE: [firebird-support] How to do Time calculation
To: firebird-support@yahoogroups.com
Date: Friday, 18 December, 2009, 5:44 PM

> Next, the result of one particular date/time minus another does not
> 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

huh?
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

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

[Non-text portions of this message have been removed]