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

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-5209:
----------------------------------

             Summary: 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)