Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Fabien Bodard
Le 23 juin 2011 16:45, Benoît Minisini a écrit : >> >> so if i store a date in a db for exemple 10:00 and then if an >> english computer query the data ... what data it display ... the date >> at the english zone ? > > No, because the database server is not Gambas. Assume that the date is alw

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Benoît Minisini
> > so if i store a date in a db for exemple 10:00 and then if an > english computer query the data ... what data it display ... the date > at the english zone ? No, because the database server is not Gambas. Assume that the date is always stored as text in a database. -- Benoît Minisini

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Fabien Bodard
Le 23 juin 2011 13:33, Benoît Minisini a écrit : >> On 06/23/2011 02:46 AM, Benoît Minisini wrote: >> >> According to some previous answers to my questions about performing >> >> arithmetic operations on dates and times, the fractional part of a date >> >> (cfloat[now] - fix[cfloat(now)]) represen

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Benoît Minisini
> On 06/23/2011 02:46 AM, Benoît Minisini wrote: > >> According to some previous answers to my questions about performing > >> arithmetic operations on dates and times, the fractional part of a date > >> (cfloat[now] - fix[cfloat(now)]) represents the time of day and the > >> integer part (fix[cflo

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Caveat
Sorry Kevin, I don't get it either. I wrote a little converter to take the millisecond value (stuff after the point) and convert it to hours minutes seconds, according to the standard algorithm... and I get a time that doesn't seem to bear much resemblance to the actual time on my system, nor to G

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread John Spikowski
On Thu, 2011-06-23 at 04:16 -0400, Kevin Fishburne wrote: > On 06/23/2011 03:54 AM, John Spikowski wrote: > > On Thu, 2011-06-23 at 03:16 -0400, Kevin Fishburne wrote: > > > >> I'm reading about GMT on Wikipedia now... How would one interpret the > >> returned values with respect to GMT? > >> > > T

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Kevin Fishburne
On 06/23/2011 03:54 AM, John Spikowski wrote: > On Thu, 2011-06-23 at 03:16 -0400, Kevin Fishburne wrote: > >> I'm reading about GMT on Wikipedia now... How would one interpret the >> returned values with respect to GMT? >> > There are 25 integer World Time Zones from -12 through 0 (GMT) to +12. >

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread John Spikowski
On Thu, 2011-06-23 at 03:16 -0400, Kevin Fishburne wrote: > > I'm reading about GMT on Wikipedia now... How would one interpret the > returned values with respect to GMT? > There are 25 integer World Time Zones from -12 through 0 (GMT) to +12. Each one is 15° of Longitude as measured East and

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-23 Thread Kevin Fishburne
On 06/23/2011 02:46 AM, Benoît Minisini wrote: >> According to some previous answers to my questions about performing >> arithmetic operations on dates and times, the fractional part of a date >> (cfloat[now] - fix[cfloat(now)]) represents the time of day and the >> integer part (fix[cfloat(now)])

Re: [Gambas-user] gb3: date/time reporting odd fractional value

2011-06-22 Thread Benoît Minisini
> According to some previous answers to my questions about performing > arithmetic operations on dates and times, the fractional part of a date > (cfloat[now] - fix[cfloat(now)]) represents the time of day and the > integer part (fix[cfloat(now)]) represents the number of days elapsed > since the b

[Gambas-user] gb3: date/time reporting odd fractional value

2011-06-22 Thread Kevin Fishburne
According to some previous answers to my questions about performing arithmetic operations on dates and times, the fractional part of a date (cfloat[now] - fix[cfloat(now)]) represents the time of day and the integer part (fix[cfloat(now)]) represents the number of days elapsed since the beginni