how to remove decimals

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

[Shreesha Subrahmanya]

x =[1.05, 2.10, 4.08, 5.09 ];

y =floor(x)

Answer 1

[Oleg Komarov]

fix(10.2)

[Go Detroit Lions]

Dude, I have to testify, everything you answer is on point the right answer!! Thanks!!

Answer 2

[Daniel Shub]

doc round

[Jan]

And: CEIL, FLOOR

[Image Analyst]

And fix(), and int32(), uint16, uint8(), etc.

[Qaiser khan Bozdar]

Worked like a pro for my code.I used it as " i = uint16(clock) ". Thank you

[Walter Roberson]

Watch out: the uint*() and int*() calls round() values.

Answer 3

[Adi Mico]

a= [2.02 3.14 0.13];

b=round(a);

Hope this can help you.

Answer 4

[Daniel Shub]

double(int64(10.2))

[Jan]

int64(10.6) => 11. The OP did not specify if rounding or truncation is wanted.

Answer 5

[yogan Sganzerla]

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.

[Walter Roberson]

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]

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.