Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-763

Out of range problem in utc_usec_to()

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.8.0, 0.9.0
    • Fix Version/s: 0.8.0, 0.9.0
    • Component/s: Function/UDF
    • Labels:
      None

      Description

      When I run the following query using the utc_usec_to function, I met an out of range error.
      Since this problem occurs only when converting to hour, it seems to relate with the time zone.

      default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05 08:00:00')::INT8*1000);
      result: 1 rows (9 B)
      ?utc_usec_to
      -------------------------------
      1365116400000000
      
      default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05 09:00:00')::INT8*1000);
      Value 24 for hourOfDay must be in the range [0,23]
      

        Attachments

          Activity

            People

            • Assignee:
              dilve Ilhyun Suh
              Reporter:
              jihoonson Jihoon Son
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: