[HIVE-3378] UDF to obtain the numeric day of an year from date or timestamp in HIVE.

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.8.1, 0.9.0
• Component/s: UDF
• Assignee: Alexander Pivovarov
• Reporter: Deepti Antony
• Created: 14/Aug/12 04:43
• Updated: 18/Apr/15 20:06
• Resolved: 18/Apr/15 20:06

Description

Hive current releases lacks a function which returns the numeric day of an year if a date or timestamp is given .The function DAYOFYEAR(date) would return the numeric day from a date / timestamp or which would be useful while using HiveQL.DAYOFYEAR can be used to compare data with respect to number of days till the given date.It can be used in different domains.

Issue Links

• relates to: HIVE-10276 Implement date_format(timestamp, fmt) UDF
• links to: https://reviews.apache.org/r/32732/