Post reply

Numeric (3,2) data type - map to C#

  • May 20, 2008 at 1:06 pm

    #187979

    I inherited a DB with a lot of fields defined as Numeric (3,2).

    How do these map to C# data types. That is, what datatype should the C# programs use to read these fields when these data types are returned in a stored procedure.

    Thanks for any help ..

    Ron G

  • May 20, 2008 at 1:53 pm

    #818202

    Numeric(3,2) is any number between -9.99 and 9.99, with up to 2 digits after the decimal place. Not sure what that maps to in C#, but it's a pretty small range of decimal numbers.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply