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

Implement from_unixtime() function

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.8.0
    • Component/s: Function/UDF
    • Labels:
      None

      Description

      It converts the specified number of seconds from Unix epoch and returns the date in the format 'yyyy-MM-dd HH:mm:ss'.

      from_unixtime(unix_timestamp[, format])
      

        Activity

        Hide
        sirpkt Keuntae Park added a comment -

        + 1 for this issue !
        After this issue is resolved, Tajo can have date type, right ?

        Show
        sirpkt Keuntae Park added a comment - + 1 for this issue ! After this issue is resolved, Tajo can have date type, right ?
        Hide
        hyunsik Hyunsik Choi added a comment -

        For non-standard part, we are following PostgreSQL. to_char() of PostgreSQL is equivalent to this function.

        http://www.postgresql.org/docs/8.4/static/functions-formatting.html

        Also, the patch of TAJO-62 already contains to_char function. If you need this function, TAJO-62 may be helpful to you.

        Show
        hyunsik Hyunsik Choi added a comment - For non-standard part, we are following PostgreSQL. to_char() of PostgreSQL is equivalent to this function. http://www.postgresql.org/docs/8.4/static/functions-formatting.html Also, the patch of TAJO-62 already contains to_char function. If you need this function, TAJO-62 may be helpful to you.
        Hide
        blrunner Jaehwa Jung added a comment -

        Thanks guys.

        If user use 'to_timestamp' function and 'to_char' function, then user can use 'from_unixtime' function.

        Show
        blrunner Jaehwa Jung added a comment - Thanks guys. If user use 'to_timestamp' function and 'to_char' function, then user can use 'from_unixtime' function.

          People

          • Assignee:
            blrunner Jaehwa Jung
            Reporter:
            blrunner Jaehwa Jung
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development