[ https://issues.jboss.org/browse/TEIID-3269?page=com.atlassian.jira.plugin... ] 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. -- This message was sent by Atlassian JIRA (v6.3.11#6341)