[SPARK-8197] date/time function: trunc

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: SQL
• Sprint: Spark 1.5 release
• Assignee: Adrian Wang
• Reporter: Reynold Xin
• Created: 09/Jun/15 06:15
• Updated: 31/Jul/15 02:23
• Resolved: 31/Jul/15 02:23

Description

trunc(string date[, string format]): string

trunc(date date[, string format]): date

Returns date truncated to the unit specified by the format (as of Hive 1.2.0). Supported formats: MONTH/MON/MM, YEAR/YYYY/YY. If format is omitted the date will be truncated to the nearest day. Example: trunc('2015-03-17', 'MM') = 2015-03-01.

Issue Links

• relates to: SPARK-8864 Date/time function and data type design
• links to: [Github] Pull Request #6988 (adrian-wang)
• links to: [Github] Pull Request #7805 (davies)