How big is your numeric value? It sounds like an outside of range problem.
Timestamp is 8 bytes, which means a pretty big number as a numeric,
9,223,372,036,854,775,808 through 9,223,372,036,854,775,807
That means that you should need at least NUMERIC (19) to capture the value.
"Pedro Caetano Barros" <pbarrosscopus.com.br> wrote in message
We need to get a timestamp field of a table as a number,
but as we use SQL70, we're not able to convert the field
to bigint type.
SQL help says its possible to do implicit conversion
between numeric and timestamp values. However, when