Results 1 to 2 of 2

Thread: Numeric data type for 17,6

  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Numeric data type for 17,6

    Hi, I need to store a dollar value for NUMBER(17,6), but when I use Decimal(17,6), I keep getting syntax error.

    How can I store a number with 17 significant digits w/6 numbers after the decimal?

  2. #2
    Join Date
    Jul 2008
    Location
    Belgium
    Posts
    17
    Hello


    I think you must use
    NUMERIC or NUM or DECIMAL of DEC

    NUMERIC(17,6) for 99999999999,999999
    NUMERIC (23,6) for 99999999999999999,999999


    Greetings
    ld_be

Posting Permissions

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