how can convert string to numeric with Query/400
i want to convert string value to numeric value is it possible with query/400
like DIGITS operator or other is it possible
The TIMESTAMP function accepts a character representation of a valid time
stamp. Because part of the time stamp is a 6-digit microsecond, use the
character string to be converted for the microsecond.
The date and time used is constant and is not important for the conversion.
The format of the microsecond is mmmmmm:
All 6 digits are required. They must be numeric. If the field is less that 6
digits, it must be padded with zeros (0) to the left. For example, 0000xx,
for a 2-digit field. If the field is more than 6 digits, do multiple
conversions and use numeric operations to calculate the correct value. If
the field requires a decimal portion, do the conversion. Then use numeric
operations to convert to the correct decimal value.
Once the time stamp is created, the MICROSECOND function can be used to
retrieve the numeric representation of the character field.
For example:
CHARACTER is a 4-digit character field in the file. Define the following
result fields:
TIMESTAMP TIMESTAMP('1995-01-01-12.00.00.00'??CHARACTER)
NUMERIC MICROSECOND(TIMESTAMP)
Ufuk Özdemir <uf...@singer.com.tr> wrote in message
news:37bd...@news.marun.edu.tr...