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

        Attachments

          Issue Links

            Activity

              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: