how to remove decimals
185 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hello all,
I have data with secons just for example
1.05, 2.10, 4.08, 5.09 ... etc.
I really dont want the decimal points in seconds. I just want say for above example like 1, 2, 4, 5 etc... I want to remove the decimal points completely. Can anyone suggest what code I have to use..
Thanks in advance
1 Commento
Risposte (5)
Oleg Komarov
il 27 Lug 2011
fix(10.2)
1 Commento
Go Detroit Lions
il 27 Nov 2018
Dude, I have to testify, everything you answer is on point the right answer!! Thanks!!
Daniel Shub
il 27 Lug 2011
doc round
4 Commenti
Qaiser khan Bozdar
il 2 Feb 2020
Worked like a pro for my code.I used it as " i = uint16(clock) ". Thank you
yogan Sganzerla
il 4 Giu 2021
I have a similar question...
my vector in matlab is V = [1;2;3;4] and I would like to create a table with this vector in SQL.
However, what is appearing in SQL is V = [1.000000000;2.000000000;3.000000000;4.000000000;5.000000000].
I wanna the vector to be without the decimal part IN SQL.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/642185/image.png)
2 Commenti
Walter Roberson
il 5 Giu 2021
When you create the table() for use with sqlwrite(), https://www.mathworks.com/help/database/ug/database.odbc.connection.sqlwrite.html then as an experiment, store an integer data type into the table entry. For example,
t = table(uint16(V), 'VariableNames', 'Var1');
and then sqlwrite() that.
This assumes that the table does not already exist in SQL. If the table already exists, then you might need to change the schema for that variable to one of the int datatypes; https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver15
yogan Sganzerla
il 6 Giu 2021
Thank you for your replay Walter, however this is not what I am looking for....
I already know how to create a table im Malab and how to import in SQL. My problem is regarding the variable type in SQL. Even using uint16(V) the table in SQL has been saved asV = [1.000000;2.0000000;...5.0000000] as you can see in the photo below
%% DECLARATION
theDataBaseName = '****';
theDataBaseUser = '****';
theDataBasePassword = '****';
theDataBaseDriver = 'org.mariadb.jdbc.Driver';
theDataBaseIP = '****';
tablename = 'Test';
%% START PROGRAM
theConnection = database(theDataBaseName, theDataBaseUser, theDataBasePassword, theDataBaseDriver, strcat('jdbc:mysql://',theDataBaseIP,'/'));
id =1:5;
id = id';
sending = table(uint16(id),'id')
sqlwrite(theConnection,tablename,sending)
close(conn)
The photo below shows the variable Sending and id in MATLAB
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/643385/image.png)
and here how it was saved in SQL.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/643390/image.png)
As you can see, appears the decimal part as it was saved in SQL as decimal(38,16) instead of bigint(20) for example.
Vedere anche
Categorie
Scopri di più su Axis Labels in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!