Re: Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 21 May 2008 14:29:53 +0200
Message-ID: <bf98b$483415c1$524b5c40$7213@cache6.tilbu1.nb.home.nl>

Don't...

Misuse data types, that is. You want date and or time info - store in in an appropriate data type column; see Tom Kytes comment:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1400155533292

-- 

Regards,
Frank van Bortel

Received on Wed May 21 2008 - 07:29:53 CDT

This message: [ Message body ]
Next message: Frank van Bortel: "Re: Oracle Merge Statement -sample query"
Previous message: Frank van Bortel: "Re: TOAD Formatter reports syntax error on collection set operators"
In reply to: Fleetie: "Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column"
Next in thread: news.verizon.net: "Re: Pro*C: Loss of Decimal Places INSERTing From "double" Host Var into NUMBER(16,6) Column"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message