Strange DIGITS() behavior

[Per Kristian S�reide]

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?   Regards, PK S�reide