[jira] Commented: (HIVE-911) Add weekofyear UDF

["Luis Ramos (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12788276#action_12788276 ] 

Luis Ramos commented on HIVE-911:
---------------------------------

Works, but not ISO standard. If you don't mind the week starting on Monday then it works. I think we could update this to follow MySQL with the options of modes. At least we can update it to allow the user to select from Monday or Sunday as the starting day of the week.

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_week

Thanks.

> Add weekofyear UDF
> ------------------
>
>                 Key: HIVE-911
>                 URL: https://issues.apache.org/jira/browse/HIVE-911
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Paul Yang
>            Assignee: Paul Yang
>             Fix For: 0.5.0
>
>         Attachments: weekofyear.3.patch
>
>
> Provide a way for users to get the week number for a date, similar to weekofyear() in MySQL.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.