(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