Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3F9E710896 for ; Mon, 23 Dec 2013 05:51:57 +0000 (UTC) Received: (qmail 16446 invoked by uid 500); 23 Dec 2013 05:51:54 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 16355 invoked by uid 500); 23 Dec 2013 05:51:53 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 16337 invoked by uid 99); 23 Dec 2013 05:51:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Dec 2013 05:51:52 +0000 X-ASF-Spam-Status: No, hits=-2000.5 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 23 Dec 2013 05:51:50 +0000 Received: (qmail 14546 invoked by uid 99); 23 Dec 2013 05:50:51 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Dec 2013 05:50:51 +0000 Date: Mon, 23 Dec 2013 05:50:51 +0000 (UTC) From: "Keuntae Park (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (TAJO-449) Implement extract() function MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org Keuntae Park created TAJO-449: --------------------------------- Summary: 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*) *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: - centry - 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 - 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)