hive datediff

在Hive中，datediff函数用于计算两个日期之间的天数差。它的语法是datediff(date1, date2)，其中date1和date2是以字符串形式表示的日期，可以是以下两种格式之一：yyyy-MM-dd HH:mm:ss或yyyy-MM-dd。该函数返回date1和date2之间的天数差，如果date1早于date2，则结果为负数。例如，如果我们执行select datediff('2019-06-25','2019-06-20')，将返回5，而执行select datediff('2019-06-25','2019-06-27')，将返回-2。\[1\]\[2\]\[3\]
#### 引用[.reference_title]
- *1* [Hive三个内置date函数：datediff、date_sub、date_add用法](https://blog.csdn.net/wx1528159409/article/details/93639721)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [Hive计算日期差](https://blog.csdn.net/qq_32252917/article/details/78198715)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]