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

Out of range problem in utc_usec_to()

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 0.8.0, 0.9.0
    • 0.8.0, 0.9.0
    • Function/UDF
    • 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

        1. TAJO-763.patch
          5 kB
          Ilhyun Suh

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment