471,306 Members | 936 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

convert number to float

karthickkuchanur
156 100+
hai,
i want to alter my data type into number to float
i execute query like
alter table preducationalhistory modify percentage float(3)
but i have the error in it please reply
Feb 2 '08 #1
3 8336
amitpatel66
2,367 Expert 2GB
hai,
i want to alter my data type into number to float
i execute query like
alter table preducationalhistory modify percentage float(3)
but i have the error in it please reply

First thing you need to check is that the column for which you are changing datatype is empty. If the data exists in the column then you will not be able to change the data type of the column.

secondly, Please provide what exactly is the error so that our experts could help you out in a better way.
Feb 2 '08 #2
karthickkuchanur
156 100+
First thing you need to check is that the column for which you are changing datatype is empty. If the data exists in the column then you will not be able to change the data type of the column.

secondly, Please provide what exactly is the error so that our experts could help you out in a better way.
thank u very much ,i try to modify the datatype with value ,yes u r right thanks a lot
Feb 4 '08 #3
amitpatel66
2,367 Expert 2GB
thank u very much ,i try to modify the datatype with value ,yes u r right thanks a lot
you are welcome :)

MODERATOR
Feb 4 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by jaijai_kumar | last post: by
9 posts views Thread by GRoll21 | last post: by
2 posts views Thread by Goran | last post: by
9 posts views Thread by FalkoG | last post: by
2 posts views Thread by Chi Tang | last post: by
4 posts views Thread by Gav | last post: by
7 posts views Thread by Partho | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.