[
https://issues.apache.org/jira/browse/TAJO-449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-449:
------------------------------
Fix Version/s: 0.8-incubating
Status: Patch Available (was: Open)
> 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
> Fix For: 0.8-incubating
>
> Attachments: TAJO-449_5.patch
>
>
> 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)
