[teiid-issues] [JBoss JIRA] (TEIID-2686) select PARSETIMESTAMP( '2012-10-20 00:00:00', 'yyyy-mm-dd hh:mm:ss' ) return 2012-01-20 00:00:00.0 as result
Joseph CHIDIAC (JIRA)
jira-events at lists.jboss.org
Fri Oct 4 05:15:04 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12809349#comment-12809349 ]
Joseph CHIDIAC commented on TEIID-2686:
---------------------------------------
It's related to the date Format
it should be 'yyyy-MM-dd hh:mm:ss' instead of 'yyyy-mm-dd hh:mm:ss'
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list