SQL怎么让回复时间显示为:1小前,2小前,1天前,.......

[xm0592]

数据表里的回复记录是具体的时间,但是显示时怎么让回复时间显示为:1小前,2小前,1天前,.......

sql 语句怎么写啊??

[ld_thinking]

查datediff()

[xm0592]

有没有知道要怎么写的啊???

[honkerhero]

用case()then

[xm0592]

case (datediff('h',hhdate,DateTime.Now()) <1) then datediff('n',hhdate,DateTime.Now())+'分钟前' as hhdate

这样写出错,偶还是不知道要怎么写,哪位高手可以帮写一个吗

[coowoo]

declare @date datetime
set @date='2007-1-12'
select case
when datediff(hh, @date,getdate()) < 24 then str(datediff(hh, @date,getdate())) + '小时前'
when datediff(hh, @date,getdate()) >= 24 then str(datediff(dd, @date,getdate())) + '天前'
end

[xm0592]

SqlStr = "select top 20 hid,htype,hname,husername,hnum,case when datediff('hh',hhdate,DateTime.Now()) < 60 then str(datediff('nn',hhdate,DateTime.Now()))+'小时前' as hhdate end from quan_hua order by hhdate desc";

偶这样写还是出错啊

[coowoo]

SqlStr = "select top 20 hid,htype,hname,husername,hnum,case when datediff('hh',hhdate,DateTime.Now()) < 60 then str(datediff('nn',hhdate,DateTime.Now()))+'小时前' -->as hhdate<--end from quan_hua order by hhdate desc";

移到end 后面

[xm0592]

SqlStr = "select top 20 hid,htype,hname,husername,hnum,case when datediff('hh',hhdate,DateTime.Now()) < 60 then str(datediff('nn',hhdate,DateTime.Now()))+'小时前' end as hhdate from quan_hua order by hhdate desc";

这样吗,和开始的错误是一样的,
错误提示是:
错误原因：为 datediff 指定了无效的参数 1。