Subject Re: [firebird-support] Re: Hourly rate
Author Lester Caine
Martijn Tonies wrote:

>>>I fail to see what this has to do with the TIME datatype?
>>This was proof of TIME is not meaning of real-time.
>>There is no real-time. Using of meridian is not must.
>>Lets make a techo fantasy..
>>You are going to Mars' office department of Upscene.
>>What TIME system will you use and store to TIME field in there?
>>Will you use mars merdians?(i am sure there must be a greenwich of
>>Or are you say: hey TIME type is incompatable for here, we need a
>>new datatype for Mars.
> The TIME datatype is valid for our little planet only.

Actually since time is stored as a fraction of a day, then the Mars
version would be a fraction of the Mars day, and you just change the
display functions.
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 ;) )

Lester Caine
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.