select
round(
(cast(timefield0 as date) - cast(timefield1 as date))
* 24 * 60
) as diff_minutes
from table
转载于:https://my.oschina.net/jingshishengxu/blog/2054439
select
round(
(cast(timefield0 as date) - cast(timefield1 as date))
* 24 * 60
) as diff_minutes
from table
转载于:https://my.oschina.net/jingshishengxu/blog/2054439