时间做差取整问题

Question

本帖最后由 wynlc 于 2014-02-24 09:29:38 编辑

Answer 1

select datediff(MINUTE,'2014-02-15 09:15','2014-02-15 09:59')/60
這樣行嗎？

Answer 2

select datediff(n,'2014-02-15 09:15','2014-02-15 09:59')/60
select datediff(n,'2014-02-15 09:15','2014-02-15 10:00')/60
select datediff(n,'2014-02-15 09:15','2014-02-15 10:15')/60
select datediff(n,'2014-02-15 09:15','2014-02-15 11:15')/60