<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Definition of field type as TIMESTAMP via UI for mysql table is systematically modified to DATETIME."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119135#c15">Comment # 15</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Definition of field type as TIMESTAMP via UI for mysql table is systematically modified to DATETIME."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119135">bug 119135</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>On pc Debian x86-64 with master sources updated today + native mysqlc +
5.5.5-10.3.22-MariaDB-1 I could reproduce this.
I wonder if it could be due to the fact that in JDBC, there's only TIMESTAMP
(see
<a href="https://docs.oracle.com/cd/A97337_01/ias102_otn/buslog.102/bc4j/bc_abcdatatypes.htm">https://docs.oracle.com/cd/A97337_01/ias102_otn/buslog.102/bc4j/bc_abcdatatypes.htm</a>)
so not present in
<a href="https://opengrok.libreoffice.org/xref/core/offapi/com/sun/star/sdbc/DataType.idl?r=19c4d8d2">https://opengrok.libreoffice.org/xref/core/offapi/com/sun/star/sdbc/DataType.idl?r=19c4d8d2</a>
Perhaps should we use "OTHER"?
79 /** indicates that the SQL type is database-specific and
80 gets mapped to an object that can be accessed via
81 the method com::sun::star::sdbc::XRow::getObject().
82 */
83 const long OTHER = 1111;
DATETIME and TIMESTAMP are quite similar, according to Mysql website:
(<a href="https://dev.mysql.com/doc/refman/8.0/en/datetime.html">https://dev.mysql.com/doc/refman/8.0/en/datetime.html</a>)
The DATETIME type is used for values that contain both date and time parts.
MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD hh:mm:ss' format.
The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
The TIMESTAMP data type is used for values that contain both date and time
parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19
03:14:07' UTC.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>