[teiid-issues] [JBoss JIRA] (TEIID-3269) Oracle pushdown time formatting incorrect

[Juraj Duráni (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Juraj Duráni reopened TEIID-3269:
---------------------------------


Now the Teiid ignores some options. But not always.
E.g.:
'F MMM-dd-yyyy G' --> ' Jan-01-2000 AD'
'F MMM-dd-yyyy G u' --> '1 Jan-01-2000 AD 6'
'F MMM-dd-yyyy G u ' --> ' Jan-01-2000 AD  '
'F MMM-dd-yyyy G u hh-HH' --> ' Jan-01-2000 AD  12-00'

I tried to add all options (according to http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html):
'MMM-dd-yyyy(YYYY)[DDD] G hh(HH):mm:ss.SSS w-W--F-E--u-a--k-K--z-Z-X' --> 'Jan-01-2000(2000)[001] AD 12(00):00:00.000 1-1--1-Sat--6-AM--24-0--CET-+0100-+01'
but with additional space at the end:
'MMM-dd-yyyy(YYYY)[DDD] G hh(HH):mm:ss.SSS w-W--F-E--u-a--k-K--z-Z-X ' --> 'Jan-01-2000()[001] AD 12(00):00:00.000 ----Sat---AM------- '

I tried same queries with MariaDB and did not realize any problem.

> Oracle pushdown time formatting incorrect
> -----------------------------------------
>
>                 Key: TEIID-3269
>                 URL: https://issues.jboss.org/browse/TEIID-3269
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.7.1, 8.9.1, 8.10
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.7.1, 8.9.1, 8.10
>
>
> Oracle formatting cannot control the number of digits displayed in the same way as Java formatting, needs to AM instead of PM, and needs better handling for ERA.



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)