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

The hour values are different between current_time() and extract from current_time()

    Details

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

      Description

      Extract function (especially from time) uses DateTimeUtil.toUserTimezone(). So using it on current_time() causes result difference.


      select current_time();
      > 07:04:32.987

      select extract(hour from current_time());
      >16.0

        Issue Links

          Activity

          Hide
          eminency Jongyoung Park added a comment -

          Fixing this should be considered with TAJO-1063.

          Show
          eminency Jongyoung Park added a comment - Fixing this should be considered with TAJO-1063 .
          Hide
          eminency Jongyoung Park added a comment -

          This issue is resolved by TAJO-1191.

          Show
          eminency Jongyoung Park added a comment - This issue is resolved by TAJO-1191 .

            People

            • Assignee:
              eminency Jongyoung Park
              Reporter:
              eminency Jongyoung Park
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development