select (unix_timestamp(checktime,'yyyy-MM-dd HH:mm')- unix_timestamp(applytime,'yyyy-MM-dd HH:mm'))/60,checkuser from tableau.home_person_check_time limit 10;
hive 计算两个时间相差的分钟
最新推荐文章于 2024-06-26 09:31:09 发布
select (unix_timestamp(checktime,'yyyy-MM-dd HH:mm')- unix_timestamp(applytime,'yyyy-MM-dd HH:mm'))/60,checkuser from tableau.home_person_check_time limit 10;