Inversion of convert(string, ...) and parseXXX(string, ...) is not always possible. ----------------------------------------------------------------------------------- Key: TEIID-744 URL: https://issues.jboss.org/browse/TEIID-744 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 The parsing routines for date and numeric types from string allow for non-canonical string forms. Inverting the convert or parse assumes that the format matches exactly (no additional trailing 0's for example) and there is no leading/trailing ws.