In SQL ......
"reading_i" is smallmoney
"reading_f" is smallmoney
CAST(ABS((reading_i - reading_f)) AS VARCHAR)
I want four decimal places alwaysfor example
reading_i = 3.123
reading_f = 1.23
I want 1.8930 (always four decimal places)
I am sure this is a beginners question, but I need to convert .0000 (smallmoney) to .00 in SQL statement to display in label controls ( since I have 3 labels that display the column, it wld probably be easier to convert in SQL than to convert each label control.)
View 3 RepliesBelow one is model table, am getting strange issue, i dont know how overcome this issue
[Code]....
Even i tried to convert the varchar to numberic, and also am getting same issue.
Can any one please guide, how to convert the above one.
Select number,empname,empfathername from emp
where number column is float data type
I need first four dights of number where it consists 10 digits.
num is 1234567890
O/P like to be
1234
I have heard that even though the maximum varchar size is 8000, that we should not go higher than 7500 for the size value. What is the logic behind this advice?
View 1 RepliesI have two database.one is "TEMS1" and another one is "TEMSLIVE"
"TEMS1" is my local database.
"TEMSLIVE" is client database.
my application is working fine while connecting to my local database. when connecting to client database("TEMSLIVE") it's shows "Msg 457, Level 16, State 1, Procedure GET_MY_TRAVEL_PENDING_ACTIONS, Line 53 Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict." this error. i have compared "TEMS1" and "TEMSLIVE" stored procedure(GET_MY_TRAVEL_PENDING_ACTIONS),but both are identical only.
In my database im storeing date as varchar. Now i want to display the table in grid view sorted by date.So how to convert varchar to datetime.
Im trying the following querry but its not working.
SELECT
[Name],
convert(datetime
,103,[sdate]),
[place], [country],
FROM [table]
I am trying to get text box values into a database from a asp.net form. In my SQL server database I have defined the field emailID as nvarchar(50) and I still get the error messageconversion failed when converting the varchar value abcd@efg.com to type int" I am not trying to convert it int so my guess is SQL server is doing some kind of implicit conversion.
View 2 RepliesI have a grid view with manual sorting. In some cells, the data are numeric and datetime. But due to some constrains, the data type on tables are varchar. The problem here is when I sorting those numeric data, it is treated as varchar.Eg: 1, 12, 13, 2, 23, 3, ...But I wanted the order to be: 1, 2, 3, 12, 13, 23, ...I have tried these method, but it doesnt works.
[Code]...
I have 6E-11,4.4E-11 values in db and I am converting it to decimal. I have C# code:
string mystring = "6E-11";
decimal myno =Decimal.Parse (mystring, System.Globalization.NumberStyles.AllowExponent);
but it still not work.
I have a string, that could look like "123,34", "123123,09", "1234", "123.34", "123123.09"
(Stringrepresentation of 10,2 decimal that will be stored into a MySql DB)
Due to the culture of the ASP.net thread may differ, because my application supports localization, I need to find a safe way to convert the most likely user input into a decimal.
How is that possible?
I tried various Decimal.Parse attemps, that all failed so far.
Solution:
My final solution was a mixed one. I used string replace to ensure my date is formatted into the specified CultureInfo I used for parsing
how to convert decimal to INR currency in asp.net C#. like- 28999345 into 2,89,99,345
View 2 Replieshow to convert the string to 3 decimal place?i want 0.033 for below:
[Code]....
[Code]....
When running our web application the following message appears:
Failed to convert parameter value string to decimal. We believe that the problem might be with the sequence which generates the user_id. The user_id should be the output after successful insert of record. The stored procedure works well from within the DB and Visual Studio. Our DB version: 11gR1 on Windows.The web form has a button event with this c#-code:
[Code]....
[Code]....
i have a strange error creaping into my web app but am unsure as to how to fix it. When i run this code on my debug workstation it works fine but when i transfer it to my server things seam to go wrong.
dev station (windows 7) + VS2010
regional and language settings all set to uk
server (windows 2008r2)
regional and language settings all set to uk
What seams to be happening is that when converting a string to a double it works correctly on the dev environment but moves the decimal place to the end on the server.
example code(vb)
dim lat as string = "52.983829"
dim long as string = "-0.036500"
dim latint as double = lat
dim longint as double = long
now on the dev server the value of latint is 52.983829 as you might expect but on when published to the server it becomes 52983829.0 the same with longint on the dev staion it is -0.036500 but on the server it becomes -36500.0 i get equally confusing problems if i try to change it to an integer instead.
is it possible to convert a Currency value $100.00 to a decimal value of 100.00?
View 1 Repliesi need to convert decimal amount to words for ex: 40300 the Result Should be: Fourty Thousand Three Hundred Rupees only if 40300.35 then: Fourty Thousand Three Hundred Rupees and Thirty Five Paise only.i have tried many Syntax and Functions bt nthing is Working Correctly,
View 1 RepliesI have one dropdownlist control.
But when I Convert It.
It is giving me error:-
System.FormatException: Input string was not in a correct format.
decimal addDomain = Convert.ToDecimal(ddlAddDomains.SelectedValue);
i want to know how to convert number to word , i want only number no decimal or currency .is there any third party tool?
View 1 Repliesconvert below datetime value which is as varchar datatype to another datetimeformat as varcharchar datatype
2010-05-19T13:05:08.6Z
how can set length of varchar more then 8000?
View 3 RepliesI know that varchar(n) in sql server specifies that a variable character of n bytes can be stored But what value of "n" should I choose if I have to store a string of say 100 character in that field. I am not able to decide the size of varchar when creating a table in database when I have to store a string of say 50 characters or string or 100 or say 1000 characters.
View 8 RepliesI'm trying to compare a string from a label to a varchar(50) in my database. String Occasion = '1 2010-07-07 10:00' compared to varchar(50) OccasionID = '1 2010-07-07 10:00'
[Code]....
[Code]....
I've checked that the values really are identical in the debug. I was under the impression that no conversion is neccessary between string and varchar, but maybe I'm wrong.
I am using sql server 2008. Could anyone tell me the differance between varchar(25) and nvarchar(25)? Which is more efficient?
View 3 RepliesIf I enter the a location of: Latitude = 28 Degrees, 45 Minutes, 12 Seconds Longitude = 81 Degrees, 39 Minutes, 32.4 Seconds. It gets converted into Decimal Degrees format to be stored in the database with the following code:
Coordinates coordinates = new Coordinates();
coordinates.LatitudeDirection = this.radLatNorth.Checked ? Coordinates.Direction.North : Coordinates.Direction.South;
coordinates.LatitudeDegree = this.ConvertDouble(this.txtLatDegree.Text);
coordinates.LatitudeMinute = this.ConvertDouble(this.txtLatMinute.Text);
coordinates.LatitudeSecond = this.ConvertDouble(this.txtLatSecond.Text);
coordinates.LongitudeDirection = radLongEast.Checked ? Coordinates.Direction.East : Coordinates.Direction.West;
coordinates.LongitudeDegree = this.ConvertDouble(this.txtLongDegree.Text);
coordinates.LongitudeMinute = this.ConvertDouble(this.txtLongMinute.Text);
coordinates.LongitudeSecond = this.ConvertDouble(this.txtLongSecond.Text);
//gets the calulated fields of Lat and Long
coordinates.ConvertDegreesMinutesSeconds();
In the above code, ConvertDouble is defined as:
private double ConvertDouble(string value)
{
double newValue = 0;
double.TryParse(value, out newValue);
return newValue;
}
and ConvertDegreesMinutesSeconds is defined as:
public void ConvertDegreesMinutesSeconds()
{
this.Latitude = this.LatitudeDegree + (this.LatitudeMinute / 60) + (this.LatitudeSecond / 3600);
this.Longitude = this.LongitudeDegree + (this.LongitudeMinute / 60) + (this.LongitudeSecond / 3600);
//adds the negative sign
if (LatitudeDirection == Direction.South)
{
this.Latitude = 0 - this.Latitude;
}
else if (LongitudeDirection == Direction.West)
{
this.Longitude = 0 - this.Longitude;
}
}
If I don't make any change to the latitude or longitude and I click Apply Changes which basically does the above calucation again, it generates a different latitude and longitude in the database. This happens every time I go to edit it and don't make a change (I just click Apply Changes and it does the calculation again with a different result). In the above scenario, the new Latitude and Longitude is: Latitude = 28 Degrees, 45 Minutes, 12 Seconds Longitude = 81 Degrees, 40 Minutes, 32.4 Seconds If I do it again, it becomes:
Latitude = 28 Degrees, 45 Minutes, 12 Seconds Longitude = 81 Degrees, 41 Minutes, 32.4 Seconds The other part of this is that when I go into edit, it takes the decimal degrees format of the latitude and longitude and converts it to the degrees minutes seconds format and puts them into their respective textboxes. The code for that is:
public void SetFields()
{
Coordinates coordinateLocation = new Coordinates();
coordinateLocation.Latitude = this.Latitude;
coordinateLocation.Longitude = this.Longitude;
coordinateLocation.ConvertDecimal();
this.radLatNorth.Checked =
coordinateLocation.LatitudeDirection == Coordinates.Direction.North;
this.radLatSouth.Checked = !this.radLatNorth.Checked;
this.txtLatDegree.Text = coordinateLocation.LatitudeDegree.ToString().Replace("-", string.Empty);
this.txtLatMinute.Text = Math.Round(coordinateLocation.LatitudeMinute, 0).ToString().Replace("-", string.Empty);
this.txtLatSecond.Text = Math.Round(coordinateLocation.LatitudeSecond, 2).ToString().Replace("-", string.Empty);
this.radLongEast.Checked =
coordinateLocation.LongitudeDirection == Coordinates.Direction.East;
this.radLongWest.Checked = !this.radLongEast.Checked;
this.txtLongDegree.Text = coordinateLocation.LongitudeDegree.ToString().Replace("-", string.Empty); ;
this.txtLongMinute.Text = Math.Round(coordinateLocation.LongitudeMinute, 0).ToString().Replace("-", string.Empty);
this.txtLongSecond.Text = Math.Round(coordinateLocation.LongitudeSecond, 2).ToString().Replace("-", string.Empty);
}
From the above examples, you can see that the Minute kept increasing by 1, which would indicate why it is generating a different latitude and longitude in decimal degrees in the database, so I guess the problem is more in the above area, but I am not sure where or why it is doing it?
public void ConvertDecimal()
{
this.LatitudeDirection = this.Latitude > 0 ? Direction.North : Direction.South;
this.LatitudeDegree = (int)Math.Truncate(this.Latitude);
if (LatitudeDirection == Direction.South)
{
this.LatitudeDegree = 0 - this.LatitudeDegree;
}
this.LatitudeMinute = (this.Latitude - Math.Truncate(this.Latitude)) * 60;
this.LatitudeSecond = (this.LatitudeMinute - Math.Truncate(this.LatitudeMinute)) * 60;
this.LongitudeDirection = this.Longitude > 0 ? Direction.East : Direction.West;
this.LongitudeDegree = (int)Math.Truncate(this.Longitude);
if (LongitudeDirection == Direction.West)
{
this.LongitudeDegree = 0 - this.LongitudeDegree;
}
this.LongitudeMinute = (this.Longitude - Math.Truncate(this.Longitude)) * 60;
this.LongitudeSecond = (this.LongitudeMinute - Math.Truncate(this.LongitudeMinute)) * 60;
}
