|
Per
Kristian S�reide wrote:
> Having a table with a column of type
FIXED(8) containing dates,
> I get the following result on query > 'SELECT datefield, DIGITS(datefield) FROM datetable': > > 20030908, 20030908 > 20030909, 20030909 > 20030910, 02003091 > 20030911, 20030911 > > It seems fields ending with 0 get's messed up. > > I'm running on version 7.4.3.27 > > Any comments? 1. oops, DIGITS
has a bug, I agree, will be fixed.
2. use CHR, it
will do what you want
3. Why do you
have FIXED(8) as date and not the date-datatype itself?
Then no such conversion would be needed. Or don't you
like the
date-and-time-format returned?
Elke
SAP Labs
Berlin
|
- Strange DIGITS() behavior Per Kristian S�reide
- Zabach, Elke
