Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@tajo.incubator.apache.org
Date: Tue, 7 Jan 2014 11:00:50 +0000 (UTC)
From: "Keuntae Park (JIRA)" <jira@apache.org>
To: dev@tajo.incubator.apache.org
Message-ID: <JIRA.12686110.1387777849069.53786.1389092450435@arcas>
In-Reply-To: <JIRA.12686110.1387777849069@arcas>
References: <JIRA.12686110.1387777849069@arcas>
Subject: [jira] [Comment Edited] (TAJO-449) Implement extract() function
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/TAJO-449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13864093#comment-13864093 ] 

Keuntae Park edited comment on TAJO-449 at 1/7/14 10:59 AM:
------------------------------------------------------------

I created a review request in RB https://reviews.apache.org/r/16681/

Please review it.


was (Author: sirpkt):
I created a review request in RB https://reviews.apache.org/r/16681/

Please check it.

> Implement extract() function
> ----------------------------
>
>                 Key: TAJO-449
>                 URL: https://issues.apache.org/jira/browse/TAJO-449
>             Project: Tajo
>          Issue Type: New Feature
>            Reporter: Keuntae Park
>            Assignee: Keuntae Park
>            Priority: Minor
>
> EXTRACT (*field* FROM *source*)
> it returns *field* part of *source*.
> *source* must be a value expression of type *timestamp*, *time*, or *interval*.
> For *date* type, it should be cast to *timestamp* and used.
> *field* can be:
> - century
> - day: for *timestamp*, the day of the month (1 - 31); for *interval*, the number of days
> - decade: the year divided by 10
> - dow: the day of the week as Sunday(0) to Saturday(6)
> - doy: the day of the year (1 - 365)
> - epoch: for *timestamp*, the number of seconds since 1970-01-01 00:00:00 UTC (can be negative); for *interval* values, the total number of seconds in the interval
> - hour
> - isodow: the day of the week as Monday(1) to Sunday(7)
> - isoyear: the ISO 8601 year, which begins with the Monday of the week containing the 4th of January, so in early January or late December the ISO year may be different from the Gregorian year.
> - microseconds
> - millennium
> - milliseconds
> - minute
> - month
> - quarter: the quarter of the year (1 - 4)
> - second:the seconds field, including fractional parts
> - timezone: the time zone offset from UTC, measured in seconds
> - timezone_hour: the hour component of the time zone offset
> - timezone_minute: the minute component of the time zone offset
> - week
> - year
> Detailed explanation can be found in http://www.postgresql.org/docs/9.1/static/functions-datetime.html


--
This message was sent by Atlassian JIRA
(v6.1.5#6160)