[
https://issues.apache.org/jira/browse/TAJO-684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13925393#comment-13925393
]
Jihoon Son commented on TAJO-684:
---------------------------------
https://developers.google.com/bigquery/query-reference#datetimefunctions
This is the query reference of google BigQuery.
I think that this will be useful to understand these functions.
> Add functions about time
> ------------------------
>
> Key: TAJO-684
> URL: https://issues.apache.org/jira/browse/TAJO-684
> Project: Tajo
> Issue Type: Task
> Components: function/udf
> Affects Versions: 1.0-incubating
> Reporter: Jihoon Son
>
> 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.
> {noformat}
> tajo> select utc_usec_to_day(1274259481071200);
> 1274227200000000
> {noformat}
> We need to provide these functions by default.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
