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: