Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    6

    Unanswered: Rounding the value

    Hi,

    I am new to Informix. Can any one tell me, how can i round the value in informix.

    Regards,
    Vinothkumar S.

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Jul 2008
    Posts
    1

    Comments

    Here is the sample data

    memno|acct_num|routno|enrolldt|totalpaid|rpt_date
    100|2222|3245|2/2/2002|10|Mar
    120|4444|5678|3/2/2003|2|April
    543|6666|7676|4/4/2005|20|May
    999|8888|6900|6/7/2004|40|June



    I need the data in the format below

    memno|acct_num|routno|enrolldt|Mar|April|May|June
    100|2222|3245|2/2/2002|10|0|0|0
    120|4444|5678|3/2/2003|0|2|0|0
    543|6666|7676|4/4/2005|0|0|20|0
    999|8888|6900|6/7/2004|0|0|0|40

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •