RE: Strange DIGITS() behavior
"Zabach, Elke" <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
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