prevent sqlwrite from rounding numbers

8 次查看（过去 30 天）
Jan H
Jan H 2020-9-18
评论： Luke Simonson 2021-10-1
Hi everyone! I'm trying to write a table into a Access-database using sqlwrite and I have two problems.
1. Part of the table is a UNIX-timestamp which looks like this in the table: 1.570555200000000e+09 (Well it looks like this: 1.5706e+09 before double clicking it).
After the export to Access using sqlwrite it looks like this in the database: 1570560000
But it should look like this: 1570555200.
How can I prevent rounding the number? Rounding destroys the timestamp.
2. The rest of the table are numbers. After the export to Access they have different numbers after the point. Some have two and some have three numbers after the point.
Is it possible to specify the numbers after the point?
Many thanks in advance!!

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

回答（1 个）

Kiran Felix Robert
Kiran Felix Robert 2020-10-8
Hi Jan,
To avoiding rounding and data truncation by sqlwrite you can store the data as a string. This will also preserve the precision.
Kiran Felix Robert
  1 个评论
Luke Simonson
Luke Simonson 2021-10-1
Is there an alternative to this? This doens't work properly when the database table already exists with number formats on specific columns.
I have a specific task where I am reading data from an SQL table, making some changes to a 4 columns (out of ~60 columns total) and rewriting them to the same table (appending new entries). However, many of the numberic columns are slightly off due to rounding.

请先登录，再进行评论。

类别

在 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