how to remove decimals

284 次查看（过去 30 天）
Fire
Fire 2011-7-27
评论： yogan Sganzerla 2021-6-6
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

请先登录，再回答此问题。

回答（5 个）

Oleg Komarov
Oleg Komarov 2011-7-27
fix(10.2)
  1 个评论
Go Detroit Lions
Go Detroit Lions 2018-11-27
Dude, I have to testify, everything you answer is on point the right answer!! Thanks!!

请先登录，再进行评论。

Daniel Shub
Daniel Shub 2011-7-27
doc round
  4 个评论
显示 2更早的评论
Qaiser khan Bozdar
Qaiser khan Bozdar 2020-2-2
Worked like a pro for my code.I used it as " i = uint16(clock) ". Thank you
Walter Roberson
Walter Roberson 2020-2-2
Watch out: the uint*() and int*() calls round() values.

请先登录，再进行评论。

Adi Mico
Adi Mico 2011-7-27
a= [2.02 3.14 0.13];
b=round(a);
Hope this can help you.
Daniel Shub
Daniel Shub 2011-7-27
double(int64(10.2))
  1 个评论
Jan
Jan 2011-7-27
int64(10.6) => 11. The OP did not specify if rounding or truncation is wanted.

请先登录，再进行评论。

yogan Sganzerla
yogan Sganzerla 2021-6-4
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.
  2 个评论
Walter Roberson
Walter Roberson 2021-6-5
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
yogan Sganzerla 2021-6-6
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
and here how it was saved in SQL.
As you can see, appears the decimal part as it was saved in SQL as decimal(38,16) instead of bigint(20) for example.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by