[
https://issues.apache.org/jira/browse/OPENJPA-3041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18136521#comment-18136521
]
ASF subversion and git services commented on OPENJPA-3041:
----------------------------------------------------------
Commit bd8ccd3b9af64b36240af908f2603a3f0f8ec483 in openjpa's branch
refs/heads/master from Richard Zowalla
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=bd8ccd3b9 ]
[OPENJPA-3055] Keep the fraction of a second in EXTRACT(SECOND) on MySQL and
MariaDB
EXTRACT(SECOND) on MySQL and MariaDB returns the whole seconds only. Add
EXTRACT(MICROSECOND) / 1000000.0 to keep the fraction, as OPENJPA-3041 did
for H2. A LocalTime parameter also lost its fraction, because it was bound
as a java.sql.Time; bind and read it as a LocalTime instead.
> H2: EXTRACT(SECOND) drops fractional seconds
> --------------------------------------------
>
> Key: OPENJPA-3041
> URL: https://issues.apache.org/jira/browse/OPENJPA-3041
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Richard Zowalla
> Assignee: Richard Zowalla
> Priority: Major
> Fix For: 4.2.0
>
>
> On H2, {{EXTRACT(SECOND FROM ts)}} returns 30.0 for a timestamp with 30.5
> seconds. The Jakarta Persistence spec includes fractional seconds for SECOND.
> Derby (since OPENJPA-3029) returns 30.5. Found while testing OPENJPA-3029.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
