Properly format amount field on AS/400 DB2 SQL

Home › Forums › Tech › Database › Properly format amount field on AS/400 DB2 SQL

Tagged: , , , , ,

This topic contains 0 replies, has 1 voice, and was last updated by  VGlushkin 11 years, 3 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • 2013/01/17 at 19:08 #2342

    VGlushkin
    Participant

    Say you have a numeric field in DB2 database on AS/400 (iSeries).

    You need to divide by 100 to get cents, and you need only 2 decimals after the decimal point:

    SELECT decimal(sum(FWAA/100) ,13,2), count(*) FROM PDDTA/F5665
    
where FWDCT<>'JR' and FWCO<>'00990'

    The output will look like this:

    DECIMAL                COUNT ( * )
    
68,542,527.90           5,487

    Your users will be happy for a while.

  • Author
    Posts
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.