Best way to get whole number part of a Decimal number

Question

What is the best way to return the whole number part of a decimal  in c     This has to work for very large numbers that may not fit into an int     GetIntPart 343564564 4342   gt  gt  343564564 GetIntPart -323489 32   gt  gt  -323489 GetIntPart 324   gt  gt  324   The purpose of this is  I am inserting into a decimal  30 4  field in the db  and want to ensure that I do not try to insert a number than is too long for the field  Determining the length of the whole number part of the decimal is part of this operation

User · Answer

I think System Math Truncate is what you re looking for

User · Answer

Very easy way to separate value and its fractional part value   double  d   3 5  int i    int d  string s   d ToString    s   s Replace i               s is fractional part   5 and i is value as integer   3

User · Answer

By the way guys   int Decimal MaxValue will overflow   You can t get the  int  part of a decimal because the decimal is too friggen big to put in the int box   Just checked    its even too big for a long  Int64      If you want the bit of a Decimal value to the LEFT of the dot  you need to do this   Math Truncate number    and return the value as    A DECIMAL or a DOUBLE   edit   Truncate is definitely the correct function

User · Answer

I think System Math Truncate is what you re looking for

User · Answer

Public Function getWholeNumber number As Decimal  As Integer     Dim round   Math Round number  0      If round  gt  number Then         Return round - 1     Else         Return round     End If End Function

User · Answer

Public Function getWholeNumber number As Decimal  As Integer     Dim round   Math Round number  0      If round  gt  number Then         Return round - 1     Else         Return round     End If End Function

User · Answer

I think System Math Truncate is what you re looking for

User · Answer

I think System Math Truncate is what you re looking for

User · Answer

You just need to cast it  as such   int intPart    int 343564564 4342   If you still want to use it as a decimal in later calculations  then Math Truncate  or possibly Math Floor if you want a certain behaviour for negative numbers  is the function you want

User · Answer

You just need to cast it  as such   int intPart    int 343564564 4342   If you still want to use it as a decimal in later calculations  then Math Truncate  or possibly Math Floor if you want a certain behaviour for negative numbers  is the function you want

User · Answer

By the way guys   int Decimal MaxValue will overflow   You can t get the  int  part of a decimal because the decimal is too friggen big to put in the int box   Just checked    its even too big for a long  Int64      If you want the bit of a Decimal value to the LEFT of the dot  you need to do this   Math Truncate number    and return the value as    A DECIMAL or a DOUBLE   edit   Truncate is definitely the correct function

User · Answer

Depends on what you re doing   For instance     bankers  rounding - midpoint goes to nearest even GetIntPart 2 5   gt  gt  2 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -6   or     arithmetic rounding - midpoint goes away from zero GetIntPart 2 5   gt  gt  3 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -7   The default is always the former  which can be a surprise but makes very good sense   Your explicit cast will do   int intPart    int 343564564 5    intPart will be 343564564  int intPart    int 343564565 5    intPart will be 343564566   From the way you ve worded the question it sounds like this isn t what you want - you want to floor it every time   I would do   Math Floor Math Abs number      Also check the size of your decimal - they can be quite big  so you may need to use a long

User · Answer

Very easy way to separate value and its fractional part value   double  d   3 5  int i    int d  string s   d ToString    s   s Replace i               s is fractional part   5 and i is value as integer   3

User · Answer

By the way guys   int Decimal MaxValue will overflow   You can t get the  int  part of a decimal because the decimal is too friggen big to put in the int box   Just checked    its even too big for a long  Int64      If you want the bit of a Decimal value to the LEFT of the dot  you need to do this   Math Truncate number    and return the value as    A DECIMAL or a DOUBLE   edit   Truncate is definitely the correct function

User · Answer

Depends on what you re doing   For instance     bankers  rounding - midpoint goes to nearest even GetIntPart 2 5   gt  gt  2 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -6   or     arithmetic rounding - midpoint goes away from zero GetIntPart 2 5   gt  gt  3 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -7   The default is always the former  which can be a surprise but makes very good sense   Your explicit cast will do   int intPart    int 343564564 5    intPart will be 343564564  int intPart    int 343564565 5    intPart will be 343564566   From the way you ve worded the question it sounds like this isn t what you want - you want to floor it every time   I would do   Math Floor Math Abs number      Also check the size of your decimal - they can be quite big  so you may need to use a long

User · Answer

Depends on what you re doing   For instance     bankers  rounding - midpoint goes to nearest even GetIntPart 2 5   gt  gt  2 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -6   or     arithmetic rounding - midpoint goes away from zero GetIntPart 2 5   gt  gt  3 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -7   The default is always the former  which can be a surprise but makes very good sense   Your explicit cast will do   int intPart    int 343564564 5    intPart will be 343564564  int intPart    int 343564565 5    intPart will be 343564566   From the way you ve worded the question it sounds like this isn t what you want - you want to floor it every time   I would do   Math Floor Math Abs number      Also check the size of your decimal - they can be quite big  so you may need to use a long

User · Answer

You just need to cast it  as such   int intPart    int 343564564 4342   If you still want to use it as a decimal in later calculations  then Math Truncate  or possibly Math Floor if you want a certain behaviour for negative numbers  is the function you want

User · Answer

I hope help you        lt summary gt      Get the integer part of any decimal number passed trough a string       lt  summary gt       lt param name  decimalNumber  gt String passed lt  param gt       lt returns gt teh integer part   0 in case of error lt  returns gt  private int GetIntPart String decimalNumber        if  Decimal TryParse decimalNumber  NumberStyles Any   new CultureInfo  en-US    out decimal dn                 MessageBox Show  String     decimalNumber     is not in corret format    GetIntPart   MessageBoxButtons OK  MessageBoxIcon Error           return default int               return Convert ToInt32 Decimal Truncate dn

User · Answer

I hope help you        lt summary gt      Get the integer part of any decimal number passed trough a string       lt  summary gt       lt param name  decimalNumber  gt String passed lt  param gt       lt returns gt teh integer part   0 in case of error lt  returns gt  private int GetIntPart String decimalNumber        if  Decimal TryParse decimalNumber  NumberStyles Any   new CultureInfo  en-US    out decimal dn                 MessageBox Show  String     decimalNumber     is not in corret format    GetIntPart   MessageBoxButtons OK  MessageBoxIcon Error           return default int               return Convert ToInt32 Decimal Truncate dn

User · Answer

By the way guys   int Decimal MaxValue will overflow   You can t get the  int  part of a decimal because the decimal is too friggen big to put in the int box   Just checked    its even too big for a long  Int64      If you want the bit of a Decimal value to the LEFT of the dot  you need to do this   Math Truncate number    and return the value as    A DECIMAL or a DOUBLE   edit   Truncate is definitely the correct function

User · Answer

Depends on what you re doing   For instance     bankers  rounding - midpoint goes to nearest even GetIntPart 2 5   gt  gt  2 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -6   or     arithmetic rounding - midpoint goes away from zero GetIntPart 2 5   gt  gt  3 GetIntPart 5 5   gt  gt  6 GetIntPart -6 5   gt  gt  -7   The default is always the former  which can be a surprise but makes very good sense   Your explicit cast will do   int intPart    int 343564564 5    intPart will be 343564564  int intPart    int 343564565 5    intPart will be 343564566   From the way you ve worded the question it sounds like this isn t what you want - you want to floor it every time   I would do   Math Floor Math Abs number      Also check the size of your decimal - they can be quite big  so you may need to use a long

User · Answer

You just need to cast it  as such   int intPart    int 343564564 4342   If you still want to use it as a decimal in later calculations  then Math Truncate  or possibly Math Floor if you want a certain behaviour for negative numbers  is the function you want

[c#] Best way to get whole number part of a Decimal number

Examples related to c#

Examples related to .net

Examples related to decimal

Examples related to int