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

PARSETIMESTAMP('12:10:10', 'hh:mm:ss') returns 00:10:10

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7
    • Query Engine
    • None

      This 

      SELECT PARSETIMESTAMP('12:10:10', 'hh:mm:ss'),  PARSETIMESTAMP('13:10:10', 'hh:mm:ss')

      returns 

      1970-01-01 00:10:10.0,1970-01-01 13:10:10.0

      It seems odd to me. Shouldnt the result of PARSETIMESTAMP('12:10:10'... be 12:10:10?

              rhn-engineering-shawkins Steven Hawkins
              fnguyen_jira Filip Nguyen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: