<div>
MySQL do not have millisecond so i need to use such field.<br />
But my data require primary key on OAdateTime would the float(0,0) works?
</div>


MySQL do not have millisecond so i need to use such field.
But my data require primary key on OAdateTime would the float(0,0) works?

<div>
I got my problem solve. When create double I should just let the database decide the precision.
</div>


I got my problem solve. When create double I should just let the database decide the precision.

<div>
<div class="content wysiwyg-content">
Hello<br />
I want to store OAdateTime in MySQL column (double)<br />
<br />
What would be setting fro Length and Precision?<br />
<br />
For bigint i set lenght to 20 and 0 for precision is this alright?<br />
<br />
Thanks,
</div>
</div>


Hello
I want to store OAdateTime in MySQL column (double)

What would be setting fro Length and Precision?

For bigint i set lenght to 20 and 0 for precision is this alright?

Thanks,

MySQL set Length/decimal for Double and bigint

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.