Strange DIGITS() behavior

Per Kristian Söreide <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Organization ComActivity
Message-ID <000601c3668c$c39fcbf0$0f0714ac@comactpks> 
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.