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

Add functions about time

    XMLWordPrintableJSON

    Details

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

      Description

      Functions about time such as utc_usec_to_second(), utc_usec_to_minute(), utc_usec_to_hour(), utc_usec_to_day(), utc_usec_to_week(), utc_usec_to_year() are popularly used in many applications.
      These functions are useful when we group data with tome intervals.
      For example, utc_usec_to_day() works as follows.

      tajo> select utc_usec_to_day(1274259481071200);
      1274227200000000
      

      We need to provide these functions by default.

        Attachments

        1. TAJO-684.Henrick.03.patch.txt
          10 kB
          Alvin Henrick
        2. TAJO-684.patch
          10 kB
          Alvin Henrick
        3. TAJO-684-With-ASF-Unit-Test.patch
          13 kB
          Alvin Henrick
        4. TAJO-684-WithUnitTest.patch
          11 kB
          Alvin Henrick

          Activity

            People

            • Assignee:
              alvinhenrick Alvin Henrick
              Reporter:
              jihoonson Jihoon Son
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: