Subject | Re: [ib-support] How can I convert TIMESTAMP to DOUBLE PRECISION??? |
---|---|
Author | Vinicius |
Post date | 2002-02-15T19:41:37Z |
Yep, I want to do this
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?
Vinicius
"Nando Dessena" <nandod@...> escreveu na mensagem
news:3C6D53EF.27EB0828@......
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?
Vinicius
"Nando Dessena" <nandod@...> escreveu na mensagem
news:3C6D53EF.27EB0828@......
> Vinicius,
>
> > How can I do it?
>
> what would you expect when translating "12/12/2001 13:01:47.465" to a
> floating point value?
> remember that assumptions about the internal storage format of the data
> are not allowed in SQL.
>
> If you specify what you are trying to achieve in particular we may come
> up with an alternate solution.
> 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/
>
>
>