select PARSETIMESTAMP( '2012-10-20 00:00:00', 'yyyy-mm-dd hh:mm:ss' ) return 2012-01-20 00:00:00.0 as result -------------------------------------------------------------------------------------------------------------- Key: TEIID-2686 URL: https://issues.jboss.org/browse/TEIID-2686 Project: Teiid Issue Type: Bug Reporter: Joseph CHIDIAC Assignee: Steven Hawkins Priority: Blocker select PARSETIMESTAMP( '2012-10-20 00:00:00', 'yyyy-mm-dd hh:mm:ss' ) return 2012-01-20 00:00:00.0 as result even select PARSETIMESTAMP( '2012-12-20 00:00:00', 'yyyy-mm-dd hh:mm:ss' ) return the same result