[teiid-issues] [JBoss JIRA] (TEIID-5209) PrestoDB uses different date format pattern syntax

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5209.
-----------------------------------
    Resolution: Rejected


This isn't specific to prestodb.  The system function works as documented to support the JRE formats.  It's not expected for the system function to support, Oracle, Joda, or other formats.

> PrestoDB uses different date format pattern syntax
> --------------------------------------------------
>
>                 Key: TEIID-5209
>                 URL: https://issues.jboss.org/browse/TEIID-5209
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.x-6.4
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>
> PrestoDB uses different date format (1) than Teiid (2).
> (1) http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html
> (2) https://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
> That's why a similar query will fail as it is being pushed to PrestoDB:
> {code}
> SELECT FORMATDATE(DateValue, 'F MMM-dd-yyyy GG') FROM BQT1.SmallA
> {code}
> because (1) doesn't support 'F' pattern, whereas (2) does.
> If it is not convenient to handle in Teiid, please add a note to the docs.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)