how to remove decimals
조회 수: 278 (최근 30일)
이전 댓글 표시
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
2011년 7월 27일
fix(10.2)
댓글 수: 1
Go Detroit Lions
2018년 11월 27일
Dude, I have to testify, everything you answer is on point the right answer!! Thanks!!
Daniel Shub
2011년 7월 27일
doc round
댓글 수: 4
Qaiser khan Bozdar
2020년 2월 2일
Worked like a pro for my code.I used it as " i = uint16(clock) ". Thank you
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
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
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!