Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4428

Timestamp having 02:XX:XX as time cannot be cast to timestamp when timezone is CET and summertime

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Blocker Blocker
    • None
    • 8.12.x
    • Query Engine
    • None
    • Hide

      1. run this query:

      select cast ( '2015-03-29 02:20:09' as timestamp );;

      2. we should get correct value:

      '2015-03-29 03:20:09'

      as, for example, parseTimestamp function does:

      select parseTimestamp('2015-03-29 02:20:09', 'yyyy-MM-dd HH:mm:ss');;
      Show
      1. run this query: select cast ( '2015-03-29 02:20:09' as timestamp );; 2. we should get correct value: '2015-03-29 03:20:09' as, for example, parseTimestamp function does: select parseTimestamp( '2015-03-29 02:20:09' , 'yyyy-MM-dd HH:mm:ss' );;

      Running the following query:

      select cast ( '2015-03-29 02:20:09' as timestamp )

      I get such exception:

      2016-09-06 14:33:08,868 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) dxYkAB2TdWA6 TEIID30020 Processing exception for request dxYkAB2TdWA6.5 'TEIID30328 Unable to evaluate convert('2015-03-29 02:20:09', timestamp): TEIID30384 Error while evaluating function convert'. Originally ExpressionEvaluationException 'TEIID10060 The string representation '2
015-03-29 02:20:09' of a Timestamp value is not valid.' StringToTimestampTransform.java:67. Enable more detailed logging to see the entire stacktrace.

              rhn-engineering-shawkins Steven Hawkins
              dalex005 Dmitrii Pogorelov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: