Subject Re: [ib-support] How can I convert TIMESTAMP to DOUBLE PRECISION???
Author Vinicius
Like this
1/1/1900 00:00 is 0.0
1/1/1900 03:00 is 0.125
1/1/1900 06:00 is 0.250
2/1/1900 00:00 is 1.0
like windows!!!
Ass Vinicius

"Nando Dessena" <nandod@...> escreveu na mensagem
news:3C6D5818.C01A9A19@......
> Vinicius,
>
> > select FIELD1 from TABLE into :FLOAT;
> > FIELD1 is a time stamp
> > and I need this time in a double precision variable to make a math
> > operation.
> > How can i do this?
>
> It could be just me, but I still don't get it.
> How can you possibly do math operations on a value that is not a number?
> What would be the float equivalent of today's noon, for example?
> What that of Wednesday morning, 3 AM?
>
> Perhaps you are confusing with Delphi's TDateTime (which stores a date
> and time in a Double variable)?
> Still puzzled...
> Ciao
> --
> ____
> _/\/ando
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>