Subject Re: [firebird-support] Hourly rate Martijn Tonies 2005-10-21T17:20:40Z
> >I still don't get what it have to do with FB :-/
> >
> >if
> >450 = 1 hour then
> >1000 = x hour
> >x = 1000/450 hour
> >x = 2.22 hour = 2 hour and 13 minutes
> >
> >if the whole work cost 80 (whole work is 1000 ou 450 ?) let's assume
> >thats 1000
> >1000 = 2.22 hour = \$80
> >1 hour = 80/2.22 = \$36,04
> >
> >see you !
> >
> >
> >
> Hi Alexandre:
>
> The problem is this:
> You wrote:
>
> x = 2.22 hour = 2 hour and 13 minutes
>
> HOW do You know that 2.22 = 2 h and 13 min??
>
> The others things are ALREADY solved, what I don't know is how
> to traslate 2.22 in 02:13
>
> eg: cast( as time )?

No, this isn't a "time", it's a "duration" or "interval". Something which
Firebird doesn't support.

Format it at the client side or write a Stored Procedure for it.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com