你用int来存就是了.select datediff(day,'2001-1-1','2002-1-1') 天
select datediff(month'2001-1-1','2002-1-1') 月
select datediff(mi,'2001-1-1','2002-1-1') 分钟
select datediff(month'2001-1-1','2002-1-1') 月
select datediff(mi,'2001-1-1','2002-1-1') 分钟
---------------------^^^减
select dateadd(day,-24,'2002-12-14')
----------------^^^天或year年select dateadd(mi,100,'2002-12-14') 加分钟
例如:
declare @dd1 datetime,@dd2 datetime
select @dd1='003-08-01 22:01:07',@dd2='2003-08-01 23:11:07'
select @dd1,@dd2,convert(varchar,@dd2-@dd1,108)