Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195

    Unanswered: Scientific Number Display

    How come my numbers come out like this (3.2262E+13) when querying the database? I don't want it to do that. Is there a way to get around this? Thanks, Jeremy
    Nothing better than a good ride.

  2. #2
    Join Date
    Apr 2003
    Posts
    3
    if you run a script, write
    "set numformat 9999999999990" before you query. the output should be as you want it.

  3. #3
    Join Date
    Feb 2003
    Location
    Paris
    Posts
    38

    Re: Scientific Number Display

    Otherwise, use a format model in your query

    SELECT TO_CHAR(<column>, <format model>) ...

    Alors, you could rewrite the above post as

    SELECT TO_CHAR(<column>, '9999999999990') ...
    Cordialement

Posting Permissions

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