Hive中计算两个时间差的方式

(HOUR (CAST(applydet.RSV_END_DATE as timestamp) - CAST(applydet.rsv_begin_date as timestamp)) * 60 
			+ MINUTE(CAST(applydet.RSV_END_DATE as timestamp) - CAST(applydet.rsv_begin_date as timestamp)) ) as minu 

((unix_timestamp(applydet.RSV_END_DATE,'yyyy-MM-dd HH:mm:ss') - unix_timestamp(applydet.rsv_begin_date,'yyyy-MM-dd HH:mm:ss')) /3600 )   AS rsv_hour