Topic profile page for Decimal.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Decimal.
Topic "Decimal" was discussed 55,555 times on 1,178 sites in last 3 months
Started 1 day, 20 hours ago (2009-12-03 11:40:00)
by John G
I have a query that returns a datatable in C# from Oracle. I have done everything to make sure the queries column is a integer, but for some reason in the datatable, it is listing it as a decimal. I tried: 1) using cast in the oracle query 2) Create the column before filling the query to datatype Int32
Started 2 days, 2 hours ago (2009-12-03 05:58:00)
by mOuP$
HI Can anyone please help me to understand the pros and cons of decimal and money datatype? I have columns which will have price in INR/USD/Euro and we need 2 digits after decimal.I want the symbols also. Which one should I use? Thanks Moups
Started 2 days, 15 hours ago (2009-12-02 16:26:00)
by jack10063
Importing CSV file with Get External tab when comma as decimal separator I am trying to import a csv file using Ms Query because I want to process the data with SQL before the import. When I am at the mask "Define Text Format" I am getting an error "Text file specification field separator matches decimal separator or text ...
Started 3 days, 9 hours ago (2009-12-01 22:20:00)
by nouseforaname1982
I want to round a decimal number that may have any number of digits so only one non-zero number is shown. For example: .000123 should equal .0001; .00003 should equal .00003; .153 should equal .2; 2.347 should equal 2 I have searched the "rounding" Posts and have not found the answer. Can someone help?
Started 3 days, 13 hours ago (2009-12-01 18:40:00)
by famlam
How to get the sign that is used to indicate decimal digits? For example: in England a number would look like 4,000,000.04 In The Netherlands however the same number would be 4.000.000,04 How can I find out if the users system uses the . or the , to specify decimals?
Started 3 days, 14 hours ago (2009-12-01 17:31:00)
by PIT_1
Hi all, Im using decimal field and choose locale is Vietnamese, choose "Limit leading digits = 13 and Limit trailing degits = 0" but when i preview and enter data "1234567," (comma at end) then it change to 0. If you know this error, pls help me! Thanks & Regards, Attachments:...
Started 1 week, 1 day ago (2009-11-26 11:06:00)
by manowj
Hi Everyone, Iam struck with sending a decimal parameter to a stored procedure. Can anyone help us in this regard cm.Parameters.Add("@test", SqlDbType.Decimal);
Started 1 week, 2 days ago (2009-11-26 07:15:00)
by RSS
mario.m7 writes "Poste Italiane, the Italian postal service, suffered yesterday from an abnormal computation in ATM and credit card operations, since the decimal comma was not taken into account. The whole sum was therefore multiplied by 100, resulting in a 115,00 Euro transaction being debited as 11.500 Euro! Thousands of accounts are deep in the red and locked (link pumped through translator), ...
Started 3 days, 12 hours ago (2009-12-01 20:00:00)
by oddz
Would it be possible to replace the ? with the price and calculate new price as a result of the calculation given the below scenario in a query? Essentially I'm looking for some way to eval() in SQL I believe… I have a client who would like to be able set dynamic pricing on products based on equations being applied to the distributors price of the product. However, if I handle this in the ...
Started 3 days, 17 hours ago (2009-12-01 15:11:00)
by Andy Trezise
I'm pretty new to SQL and am a little confused as to which field type I should use to store my 'currency' type data. What's the main difference between these two data types and which would best fit the purpose? I want to store signed numerical data with up to 6 decimal places. Thanks in advance for any help....
Started 1 week, 1 day ago (2009-11-27 05:18:00)
by techfak
I had already posted this to tools-compilers@opensolaris.org, since both the compilers and the OS are involved, unfortunately to no avail. Instead, it was suggested I might have better success here, so here we go: While working to improve GCC support for Solaris, the question turned up what it would take to support decimal floating point (now ISO/IEC TR 24732:2009): see the thread ...
Started 3 days, 8 hours ago (2009-12-01 23:39:00)
by SentientParadox
I've done this before using macros, but it's a pain in the neck. What I really need is to do this using a formula if at all possible, so I can create charts of the results. I'm going to have columns of results, all of which will have digits to the right of decimal. I need to loose any and all digits to left of the decimals, but will be showing the results in ...
Started 4 days, 3 hours ago (2009-12-01 04:44:00)
by phpSimon
[RESOLVED] Prevent minus zero with number_format Hi all I'm comparing $total and $previoustotal, which are figures that end in two decimal places. I want to display the result with no decimal places. PHP Code: $result = $total - $previoustotal ; print ( "number_format($result,0)" );...
Started 2 days, 14 hours ago (2009-12-02 17:18:00)
by munkee
Hi people, Basically users have to enter the number of hours and minutes that someone has been present that day in decimal form. This is done from a computer print out and comes as said in hours and minutes which then requires the inputter to use a calculator to calculate those minutes as part of an hour. For example: 7 hours and 24 minutes = 7.4 hours since 24 minutes is .4 of an hour. ...
Started 5 days, 14 hours ago (2009-11-29 17:35:00)
by Cunning Runt
Which of these two records is better? 13-10-1 13-9-2 I honestly don't know. We play doubleheaders weekly. ps - save the "decimal scoring" comments. My first year in the league - last second type thing. I'll get the decimal thing instituted for next year if I stay in it. This post has been edited by Cunning Runt : Today, 5:37 PM
Started 2 days, 19 hours ago (2009-12-02 12:50:00)
by SRV
I have to mail merge a letter using XLS as datasource that has some currency fields and the output of the currency fields should be formatted to european format (eg: 1.234.567,99) Please note that decimal separator is comma and group seperator a dot. If could not find a suitable switch. Can someone please point me to right place? O/S: Windows XP MS Office 2003
Started 2 days, 17 hours ago (2009-12-02 14:13:00)
by SRV
I have a mail merge which has numbers (amounts) to be formatted for european regional settings ( comma as decimal seperator and dot as grouping seperator). I tried the following but it did not work. { MERGEFIELD "Net_Amount" \# #.###,00 } Using MS Office 2000 on Windows XP Appreciate you quick reply...
Started 6 days, 6 hours ago (2009-11-29 02:12:00)
by JREAM
Wondering the best one to use. I was thinking about doing a decimal 10.5, 1.10, it doesnt matter. Im just separating two values but want to save time by retrieving one row. 1,5 = level 1, 50 percent 4,9 = level 4, 90 percent etc.. Thats all im doing, should I just use VARCHAR? BTW, these are all staying under 9, so the max is 9,9
