[jira] [Commented] (OPENJPA-2755) support MySQL DATETIME and TIMESTAMP fractions (milliseconds, nanos)

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-2755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16672144#comment-16672144 ] 

ASF subversion and git services commented on OPENJPA-2755:
----------------------------------------------------------

Commit 0530b5b72ba00a3014e67c9ee4c3e8bfcddabb76 in openjpa's branch refs/heads/master from [~struberg]
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=0530b5b ]

OPENJPA-2755 OPENJPA-2555 support fractions of a second

For now just in MySQL. Should also get added to PostgreSQL.
Txs also to Ancoron Luciferis for a patch which also
gave some important input!


> support MySQL DATETIME and TIMESTAMP fractions (milliseconds, nanos)
> --------------------------------------------------------------------
>
>                 Key: OPENJPA-2755
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2755
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 3.0.0
>            Reporter: Mark Struberg
>            Assignee: Mark Struberg
>            Priority: Major
>             Fix For: 3.0.1
>
>
> MySQL supports to add a time fraction to their DATETIME and TIMESTAMP fields. E.g. DATETIME(3) to store milliseconds or DATETIME(6) for microseconds.
> This only exists as of MySQL-5.6.4 and onwards. 
> We should create proper CREATE TABLE statements for it if we detect one of those versions.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)