Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Problem in converting float to varchar Rate Topic Display Mode Topic Options
Author
 Message
 Posted Tuesday, October 21, 2008 2:47 AM
 SSC Rookie Group: General Forum Members Last Login: Tuesday, August 12, 2014 7:30 AM Points: 37, Visits: 119
 The following query truncates the decimal characters when we convert it to varchar.declare @d floatdeclare @d1 floatselect @d = 34343.454select @d1 = 676.1566545select cast (@d as varchar(50)) + CHAR (9) + cast (@d1 as varchar(50))ouput:34343.5 676.157but the required output is:34343.454 676.1566545Can anyone help to find a best solution for this ?Thanks in advance.
Post #589007
 Posted Tuesday, October 21, 2008 2:53 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, November 29, 2016 6:35 AM Points: 2,042, Visits: 2,578
 I tried the below codedeclare @d floatdeclare @d1 floatselect @d = 34343.454select @d1 = 676.1566545select cast (@d as varchar(50))select cast (@d1 as varchar(50))I got the below output.34343.453999999998676.15665449999995 karthik
Post #589011
 Posted Tuesday, October 21, 2008 5:43 AM
 Old Hand Group: General Forum Members Last Login: Friday, June 26, 2015 6:44 AM Points: 329, Visits: 476
 aravind (10/21/2008)The following query truncates the decimal characters when we convert it to varchar.declare @d floatdeclare @d1 floatselect @d = 34343.454select @d1 = 676.1566545select cast (@d as varchar(50)) + CHAR (9) + cast (@d1 as varchar(50))ouput:34343.5 676.157but the required output is:34343.454 676.1566545Can anyone help to find a best solution for this ?Thanks in advance.`declare @d floatdeclare @d1 floatselect @d = '34343.454'select @d1 = 676.1566545select cast(cast (@d as decimal(12,3)) as varchar(20)) + CHAR (9) + cast(cast (@d1 as decimal(12,3)) as varchar(20))` MadhivananFailing to plan is Planning to fail
Post #589074
 Posted Tuesday, October 21, 2008 11:38 PM
 SSCertifiable Group: General Forum Members Last Login: Yesterday @ 5:32 AM Points: 5,668, Visits: 11,156
 aravind (10/21/2008)Can anyone help to find a best solution for this ?Thanks in advance.I can.Simply by opening BOL on related topic.
Post #589593
 Posted Thursday, October 23, 2008 7:36 AM
 SSC Rookie Group: General Forum Members Last Login: Tuesday, August 12, 2014 7:30 AM Points: 37, Visits: 119
 Hi Madi,The output wont be the one I expected. The decimal should not get truncated.
Post #590440
 Posted Thursday, October 23, 2008 7:48 AM
 Old Hand Group: General Forum Members Last Login: Friday, June 26, 2015 6:44 AM Points: 329, Visits: 476
 aravind (10/23/2008)Hi Madi,The output wont be the one I expected. The decimal should not get truncated.Here it is`declare @d floatdeclare @d1 floatselect @d = '34343.454'select @d1 = '676.1566545'select cast(cast (@d as decimal(12,3)) as varchar(20)) + CHAR (9) + cast(cast (@d1 as decimal(18,7)) as varchar(20))` MadhivananFailing to plan is Planning to fail
Post #590448

 Permissions